A formula or code.

for code:
Ron gave you a link to the lastrow and lastcol functions which you have
already used per a previous thread.

Any formula should be based on the data being used. Otherwise you waste
resources checking things that don't need to be checked.

--
Regards,
Tom Ogilvy



"justme" wrote in message
...
Hi everybody,

Thank you all for your responses. I was actually looking for a formula
that
would always find the last cell in a sheet no matter which column was the
longest, i.e. last row, last column. Is there such a thing?

thank you.