The_Rock
Board Regular
- Joined
- Jul 2, 2007
- Messages
- 174
Hi Folks
Currently in my formula, I am using:
I need to change the 'currentregion' to just the data in B3:C3 (down to the end of the range).
What do I need to do?
Thanks
Currently in my formula, I am using:
Code:
Set src = ws.Range("B3:C3").CurrentRegion.Offset(1, 0)
Set dest = wssum.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
src.Copy Destination:=dest
I need to change the 'currentregion' to just the data in B3:C3 (down to the end of the range).
What do I need to do?
Thanks