different ways to copy a range?
botha822 wrote:
Whats wrong with this syntax?
WsName is a string variable that is assigned the name of a worksheet
exists.
n and i are both integer variables that are based off of For
statements.
Worksheets(WsName).Range(Cells(5, n), Cells(2415, n)).Copy _
Destination:=Worksheets("Summary").Cells(4, i)
Where is your code bugging? Are you sure your variables are being
assigned? i think you should post all of your code
AR
|