Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Used range in Excel - including top left cells

Status
Not open for further replies.

PaultheS

Programmer
May 12, 2005
92
CA
I'd like to be able to select the used range of a spreadsheet, starting from cell A1 and going down right until there's nothing left. However, The UsedRange function removes the first columns/rows if they are empty. Any suggestions on how to achieve this?
 
Have a look in the FAQ area for different ways of finding last cell in any direction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 

PaultheS,

What are you trying to do?

How are you using UsedRange?

Skip,

[glasses] [red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [tongue]
 
Skip,

I'm trying to copy the contents of a sheet onto another sheet. Now that I think about it, this method wouldn't keep the same column widths and other settings... Perhaps I should investigate a different way...

PHV, I'll do that, thanks.
 
Why not simply use the Copy method of the Worksheet object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top