I made a simple loop to go trough worksheet and to print multiple hits for .Find in a Range
Right now my code displays all cells containing any data in it.
What I would like is:
when there is a HIT to continue with .FindNext but to skip to next row
This is my sample table:
NAME VALUE 1 VALUE 2 VALUE 3 WORKER 1 somethinW1.1 somethingW1.2 WORKER 2 somethingW2.2 somethingW2.3 WORKER 3 somethingW3.1 somethingW3.3 WORKER 4 WORKER 5 somethingW5.2
This is my VBA code:
My Immediate window displays result like this:![]()
Please Login or Register to view this content.
I need somethin like this:![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Bookmarks