View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mginter@oswaldcompanies.com is offline
external usenet poster
 
Posts: 2
Default Using VBA to copy range of cells

I've monkeyed with this, too... got the solution by recording what I
would do on the sheet to make this happen...

This should work for you

Range("A3:S3").Select
Range(Selection, Selection.End(xlDown)).Select

Note: This will only work when the data in column A is continuous to
the end of the series (i.e., there are no blank cells between A3 and
the last cell in column A with data).

Hope that helps!