I’m creating a macro so I can click and drag down a formula X rows. The formula contains reference cells in another excel file that automatically increment. This is what I want. When I run the macro, the cells keep incrementing past what the original formula increments to. How do I repeat reference the incrementing cells each time the macro is run ?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro for Formula with Reference Cell
- Thread starter Lalala221
- Start date
