You must wrap your code on the Forum, it makes it easier to read & copy.
What exactly do you want to do when you loop through the ?
You must wrap your code on the Forum, it makes it easier to read & copy.
What exactly do you want to do when you loop through the ?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I have a worksheet that has multiple data that I need to copy 2 cells (side by side) and move up 1 row and over 2 cells.
I just can't figure it out how to do it. THe code I pasted isn't working the way I want it to.
Thanx
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