I don't know what you want to do if you find an empty cell but tinker with this
For the "c.Select" part of the code is where you put your own code.![]()
Sub vCheck() For Each c In Range("O5:O16, P5:P16") If c.Value <> "" Then c.Select Next c End Sub
I don't know what you want to do if you find an empty cell but tinker with this
For the "c.Select" part of the code is where you put your own code.![]()
Sub vCheck() For Each c In Range("O5:O16, P5:P16") If c.Value <> "" Then c.Select Next c End Sub
Last edited by Mordred; 08-05-2010 at 12:13 PM.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks