View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ducky ducky is offline
external usenet poster
 
Posts: 27
Default 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