S
Sethaholic
Here's the part of the code giving me trouble:
For Each rngItem In rngData
Set rngOut = rngAccounts.Find(What:=rngItem)
If rngOut Is Nothing Then
rngItem.Offset(0, 2).Value = "N/A"
Else
Set rngOut = rngOut.Offset(0, 1)
Range(rngOut, _
rngOut.End(xlDown).End(xlToRight)).Copy _
Destination:=rngItem.Offset(0, 2)
End If
Next rngItem
Next mysht
What code do I add to it so that when it copies to the destination, it
will shift the entire rows down? I've been trying so hard but i can't
seem to work it out.
I tried Destination:=rngItem.Offset(0, 2).shift(x1down)
but it doesn't work. What should I do? Please please please help.
Thanks!!
For Each rngItem In rngData
Set rngOut = rngAccounts.Find(What:=rngItem)
If rngOut Is Nothing Then
rngItem.Offset(0, 2).Value = "N/A"
Else
Set rngOut = rngOut.Offset(0, 1)
Range(rngOut, _
rngOut.End(xlDown).End(xlToRight)).Copy _
Destination:=rngItem.Offset(0, 2)
End If
Next rngItem
Next mysht
What code do I add to it so that when it copies to the destination, it
will shift the entire rows down? I've been trying so hard but i can't
seem to work it out.
I tried Destination:=rngItem.Offset(0, 2).shift(x1down)
but it doesn't work. What should I do? Please please please help.
Thanks!!