finding and selecting first empty cell in a column and offsetting it

As mentioned in the topic I want a code that does find the cell that is first one in a column containing no value.

I have :

Please Login or Register  to view this content.

But i have an error saying :"Application defined or object defined error"

After finding this cell I want code to select it.


Any ideas ?

Thanks

Rows.Count + 7 ‼ But max is Rows.Count …

Originally Posted by TMS

Please Login or Register  to view this content.

You can't have "Rows.Count + 7", nor can you go down from there and, consequently, you can't offset down from it

And the tab name needs to be in double quotes.


Regards, TMS

Many thanks.
Can you please suggest how do I offset it then?

But this will work if this is what you're after.
Change Sheet and Column references as required

Please Login or Register  to view this content.

Or as TMS suggested

Please Login or Register  to view this content.