Define a range

  • Thread starter Thread starter jlclyde
  • Start date Start date
J

jlclyde

Sheets("New").Range("A:AC" & lRow).Copy
I thought that this would work but it does not. I want to copy a
range that is A through AC on row LROW. Any thoughts?

Thanks,
Jay
 
Hi

fRow = 1
lRow = 10
Sheets("New").Range(Cells(fRow, "A"), Cells(lRow, "AC")).Copy

Regards,
Per
 
Try

Sheets("New").Range("A" & lRow & ":AC" & lRow).Copy

Hope this helps,

Hutch
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use active cell to determine range 2
Modifying Macro 3
2 macro help 7
Average Value Revisited 11
Finding a character in a text string (take3) 2
Insert row 2
Macro to Sum Two Adjacent Columns as per Text in previous Column 8
VBA selction of rows using a variable 5

Back
Top