The Resize property will extend rngFound -
For the looping look at the FindNext method.![]()
Set rngFound = rngFound.Resize(, 2) 'extend to two columns
There is a nice little example in VBA help that you can use as a framework.
The Resize property will extend rngFound -
For the looping look at the FindNext method.![]()
Set rngFound = rngFound.Resize(, 2) 'extend to two columns
There is a nice little example in VBA help that you can use as a framework.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks