I'm trying to make it select the first unhidden cell. So if A & B are hidden, it would be C1, if A & 1 are hidden, then it would be B2, and so on.
Thanks in advance.
I'm trying to make it select the first unhidden cell. So if A & B are hidden, it would be C1, if A & 1 are hidden, then it would be B2, and so on.
Thanks in advance.
Additional info may be required, is this from a filtered range?
Try something like this:
Hope this helps.Please Login or Register to view this content.
Last edited by TimK; 12-18-2009 at 12:55 AM.
Why would you have hidden cells?
I don't have access to Excel at the moment, but something like ...
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks