Repeatedly go to next non-empty cell in column

January 18, 2019

Hi,

What macro steps will allow me to go to the next non-empty cell in a column?

More specifically, I have a column, let's say A5:A99, and I'd like to know the macro steps such that the selection cursor will go to the next non-empty cell in that range, then when the macro is run again it drops to the NEXT non-empty cell in that column, and so on, until each non-empty cell in the range has been selected, starting at A5 and moving downward.

If that can be done, can the macro start over at A5 when there are no more non-empty cells, or better yet display a "Last one" message?

Thanks in advance for any guidance y'all can offer.

Please Login or Register  to view this content.

jolivanes, that was quick, and thanks.

I figured out that if it's really column J whose cells I want to test, I should change the 1 (Column A) to a 10 (Column J). I have no idea what the End(x1Up) part is, but that's OK.

What I really wanted, though, is for the macro to merely go to the next non-empty cell, which might mean the Select command but I don't know, and then do nothing except wait for me to run the macro again if I want, whereupon the cursor would go that next non-empty cell. Said another way, I don't want to display a message at all until the last non-empty cell has been selected.

hi Johnegee

if u just want to keep selecting non-blank cells after J5 try this
just select j5, if the cell below it is non empty u can press down arrow or Enter and go to that cell
else
press End and Down arrow .
This also works - no need of macro

Maybe this:

Please Login or Register  to view this content.

kmahesh, I wasn't able to get your non-macro methods to work. Maybe that's because I use a laptop whose keyboard offers fewer keys.

Still, thanks for replying.

akuini, although at first I was concerned there was no reference to a particular range, I have adapted my spreadsheet so your macro works just fine now.

Thanks for your help.

mohan.r1980, I wasn't able to figure out how to adapt your code so as not to get an error, and I've since found a macro that works well enough for my purposes.

Still, thanks for your time.

Originally Posted by Johnegee

akuini, although at first I was concerned there was no reference to a particular range, I have adapted my spreadsheet so your macro works just fine now.

Thanks for your help.

You're welcome & thanks for the feedback.