how to discard a variable that doesn't work

[fairyrak]

how to do this again until randomcell is a variable that works? (it works when I get a nonempty cell)
randomcell is the variable, and in my worksheet
rng.Cells(randomcell) might be or might not be empty depending on what the value of randomCell was



Note: I have already declared Rng and all stuff, but you are curious about the code that I'm using:

Please Login or Register  to view this content.

I know that there are things like while, do, goto, if, but what is the correct one to use here and how?

[karedog]

Maybe :

Please Login or Register  to view this content.

[Kenneth Hobson]

I would do as #2 but add an exit.

Please Login or Register  to view this content.