Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm still having a problem with getting my macro to use a variable cell
address. I'm trying to get the cursor to the cell two rows below my inported data, and then cut and paste additional calculations. The data will vary in length each time. As an example if I start with Data from A2 to A6 then I need to go to A2, count down, and in cell A8 I want to bring in additional calculations. The next time I may have data from A2 to A2000, so the additional calculations will be pasted into A2002. If I use the 'shift + ctrl' down arrow, when I enter data it sets the macro with absolute adress. so the next time I use the macro the calculations are in the wrong place. Any ideas please with greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting a variable cell address | Excel Discussion (Misc queries) | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
How do I dynamically retrieve the cell address of the last cell t. | Excel Discussion (Misc queries) | |||
Relative Macro Help on Keystrokes | Excel Discussion (Misc queries) | |||
Moving Down a Cell in Macro | Excel Discussion (Misc queries) |