finding last column/row on a worksheet containing data 1

[jluft]

is there a way to locate the last column/row on a worksheet that contains actual text? end will not work here because that simply locates the bottom-most and right-most points containing any change to a cell, whether that be something exectued previously or currently
is there a simple line or two of code for performing this?

 

[SkipVought]

Hi,

Have you tried looking in the FAQ or doing a search.

There are LOTS of examples if you do some digging.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[jluft]

i will check that out thank you