Locating the first empty cell in highlighted section

[Tommanley]

Can someone please give me a macro to highlight the cells Range("A4:S35") and find the first empty cell in that selection while keeping the Range highlighted.

[DonkeyOte]

Do you mean something like the below ?

Please Login or Register  to view this content.

handler required in case there are no blanks

(note: moved to parent Programming Forum (VBA))

[Tommanley]

That gives me the next blank column. Is there anyway i can get the next empty cell going form top to bottom of the page in the highlighted area? Could i just have the cursor on the empty cell and no message box. Sorry i wasnt more clear. Thank you very much

[broro183]

hi,

Welcome to the Forum

Here's a slight adaptation of DonkeyOte's suggestion...

Please Login or Register  to view this content.

hth
Rob

[Tommanley]

This will be perfect if you could have the cursor land on the first empty cell. It is still starting on the top of the next column

[phil_b]

same principle just loops through the columns rather than the entire range at once:

Please Login or Register  to view this content.

[Tommanley]

Exactly what i wanted. Thank you very much