0

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)
Improve this question
1
  • What are G, Y, I and AA? Commented Mar 5, 2012 at 16:44

1 Answer 1

Reset to default
3

Assuming kk and k contain the respective rows and G / Y, I / AA represent the columns, you probably mean (note the quotes):

Worksheets("spreadPar").Range("G" & kk & ":" & "Y" & kk).Copy Destination:=Worksheets("EE static").Range("I" & k & ":" & "AA" & k)
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.