VBA to find next unused cell in Named Range

Hi.

I have a named range of non-contiguous cells called "MainCategory". How can I write VBA to find the next blank cell in that range?

Thanks!

Try this:-

Please Login or Register  to view this content.

Regards Mick

Possibly...

Please Login or Register  to view this content.

Hi

Remark:

xlCellTypeBlanks means just empty cells.

@LKERN What do you mean by blank? Do you mean an empty cell or also a cell with a null string?

Thanks MickG.

This finds the blank cell and puts up a message box of the cell address, but when I hit OK, it just goes to the next box. I can't get out of the loop until I OK every msg.

I just want it to find the first blank cell and stop there. Also, what can I change to make it navigate to that cell instead of showing a message box?

Originally Posted by lecxe

Hi

Remark:

xlCellTypeBlanks means just empty cells.

@LKERN What do you mean by blank? Do you mean an empty cell or also a cell with a null string?

I'm not sure how to answer. The cells in the range have a data validation list to choose from and they default to a blank cell. I want it to choose the first cell that does not have anything chosen from the list.

Originally Posted by dangelor

Possibly...

Please Login or Register  to view this content.

I tried this and I get an error that says:Attachment 636209

Wait....I got it to work like this:

Please Login or Register  to view this content.

Thanks!

Glad to hear it!