Thread: Define a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default 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