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
|