Skip to main content
edited tags
Link
tshepang
  • 12.5k
  • 25
  • 98
  • 140
Source Link
Eva
  • 917
  • 4
  • 18
  • 23

Copy a range in an Excel sheet using vba

In below code I just want to copy a range from one sheet, which are some subsequent cells in the same row, to some subsequent cells in the same row in another sheet,

however the code does not work as expected? What do I do wrong? K and kk are just some integers, thanks for your help

Worksheets("spreadPar").Range(G & kk & ":" & Y & kk).Copy Destination:=Worksheets("EE static").Range(I & k & ":" & AA & k)