ExcelBanter - Define a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Define a range (https://www.excelbanter.com/excel-discussion-misc-queries/184147-define-range.html)

jlclyde

Define a range

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

Per Jessen

Define a range

Hi

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

Regards,
Per

"jlclyde" skrev i meddelelsen
...
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

Tom Hutchins

Define a range

Try

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

Hope this helps,

Hutch

"jlclyde" wrote:

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

All times are GMT +1. The time now is 01:39 PM.