MrExcel Publishing
Your One Stop for Excel Tips & Solutions

selecting a range of data only


Posted by Mark Henderson on January 30, 2002 3:53 PM

Here's what will be a simple one for you gurus. I have 4 columns of data, but the number of rows varies from month to month. I wish to find a way to select the cells with data only, and then copy this tange to another sheet. Basically, selecting cell A1 thru to cell D(last row with data) is what I require.

adieu
Mark


Posted by Richard S on January 30, 2002 4:38 PM

I assume you mean using a macro?
ActiveSheet.UsedRange.Name = "name"
Application.Goto Reference:="range"
Selection.Copy
will name the range you want to copy "name" then copy that range.

Richard