I am pulling in some data from the web...since the data that is pulled in can move around on me, I am using code to find a specific word and then using an offset to select and activate the first cell in a range of 10 cells I want to copy...
...now is there a code that would select the current active cell plus the 9 cells below it?? Maybe using R1C1 to have it step down 9 cells selecting all ten cells???
Of course, this would be really simple if I could count on those ten cells being in the exact same range everyime, but they aren't.
Here is my code so far:
...Now how do I also tell it to highlight and select the 9 cells under the current active cell so I can copy and move the data in all ten cells?
A code snip it or any help would be greatly appreciated!
Thanks
Bookmarks