How to locate first used (filled) cell on the sheet with no loop? 2

[vladk]

Thanks!

 

[PHV]

A starting point:
MsgBox Cells.Find("*").Address

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

 

[SkipVought]

Hi,

Also check out the UsedRange property. However, be advised that this can return unreliable results under certain conditions where the Clear or ClearContents methods have been used on a sheet (deleting without SHIFTING rows/columns).

Skip,

_[red][/red]

 

[vladk]

Hi guys!

It appears that PHV gave simple yet reliable and efficient code. Works just great!

Both of you, thank you!

vladk