Function to Find a cell with a certain property set

I need a function that will allow me to find the next cell in a range with a certain .borders property set. The problem is, I only know how to do it with a for/next loop where it selects the cell, examines it, and then evaluates it as pass/fail before moving on, and selecting a cell in that range would trigger a userform to open.

So example:
exampleCell.PNG

I'm on B26 and I would want to jump to B32 because it has the .borders set to vbRed or xlMedium or whatever.

How can I do this without using select?

Thanks for your help, you guys have always been helpful.

Hi
is this what you are after? It searches the specified range for a cell below the active cell with a particular property and gives a message box identifying the cell and asking whether the user wants to select it.

Please Login or Register  to view this content.