Used range in Excel - including top left cells

[PaultheS]

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?

 

[PHV]

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

 

[SkipVought]

PaultheS,

What are you trying to do?

How are you using UsedRange?

Skip,

_{[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!}

 

[PaultheS]

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.

 

[PHV]

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