I need code that will locate an empty cell across columns. Columns D10,
E10, F10 and G10 are with filled and the code will select the empty
cell, which will be H10.

Ogopogo5

*** Sent via Developersdex http://www.developersdex.com ***

I searched Google with: excel vba first non blank in row
and got about 15,000 hits
Here is one; it seems to answer your question
http://www.vbaexpress.com/kb/getarticle.php?kb_id=417

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"ogopogo5" wrote in message
...
I need code that will locate an empty cell across columns. Columns D10,
E10, F10 and G10 are with filled and the code will select the empty
cell, which will be H10.

Ogopogo5

*** Sent via Developersdex http://www.developersdex.com ***

Thank you Bernard for your help but the code that you found on Google
works. However I do need to have code that will find and select the
empty cell across the columns, even though the first 3 columns are empty
Any suggestion?



Ogopogo5

*** Sent via Developersdex http://www.developersdex.com ***