Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically increment cell reference
Hello,
Bit of a rookie when it comes to VBA so bare with me. I have a vlookup formula, whose target is the cell E3. E3 in turn points to a cell from another worksheet, lets say it's =July!A10. How do I have a macro run so that it increases E3's cell reference by 1 row each time? ie., 1st run =July!A11, 2nd loop =July!A12, 2nd loop =July!A13 and so on (I already have separate code that I will insert into the loop). Then I'd want the macro to stop once it reaches the last row of data on July's worksheet, which unfortunately is dynamic. Maybe the user can be prompted to select the range to run the macro for? I don't know... Any help would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to increment a cell reference in a row | Excel Discussion (Misc queries) | |||
increment cell reference in a formula | Excel Worksheet Functions | |||
Need formula to increment cell reference every 8th row | Excel Discussion (Misc queries) | |||
Increment cell reference | Excel Discussion (Misc queries) | |||
increment cell value automatically | Excel Worksheet Functions |