I'm trying to select a row of data, and am having trouble. I have a search that finds the row I want (it will change depending on the data). Now I want it to select the first 15 cells of that row so I can copy it to another sheet. Example, Row 20 has the data I want, and I want it to select A20-O15. This is what I have tried so far:
Range(ActiveCell,Offset(0,15).Select
This is one example and I know it isn't right, but it gives the idea of what I'm trying to do.
Bookmarks