Hi, I'm very new to excel programming. I have a very limited background in C++ too and no background in VBA at all. I don't even know if my descriptive title is correct. But anyway, I just want to know if it would be possible to increment a cell index so that after each loop of the function, the active cell selected is exactly n-rows away from the previous one.

Say, I have a macro that 'extracts' data from 30 worksheets and pastes these 'extracted' data into a single worksheet. After each 'run' in each of the 30 worksheets, the macro pastes the data into the destination worksheet, just below the cells where it has already pasted the data from the other worksheets. My current macro is lengthy and ugly because I copied and pasted the same function 30 times, so that I can change the activecell index 30 times. Am I making any sense?

I'm trying to shorten code by calling the same function 30 times, but with the activecell already incremented after each 'run' so that the next pasted data will be in place. Any help?