Hi all,

Ok, so what I'm trying to do is to move throughout a worksheet in Excel so that I can select a group of cells, copy and past that group, and then move on to the next group of cells. There are a few problems however:
1. The groups of cells are not predefined. I need to search for certain perameters. This isn't a problem, really, as I've written the code for this and it works fine, but it's an important factor.

2. The cells are relative to each other, which means, I can't just say, "Grab 5 rows, then go down one row and grab five more." I need something more like "Grab x number of rows with y information. Then skip a line and grab x1 number of rows with y1 information."

3. The real problem is that when I tell the vb macro to run around in Excel and find the right areas, it does that fine. however, when it comes time to select them and highlight them, it starts jumping all over the place, grabbing relative blocks instead of actual locations.

For example, if the current cell selected is D6, and I'm telling it to select E6, it goes down not one row, but five rows and over one collumn.

So, is there a way to tell excel to respond to Actual addresses?


Any ideas would be very appreciated.

Thanks,
Joshua Wise