Getting macro to copy to starting cell

S

sony654

Help. I am building a macro that always references the same worksheet totals
and should copy the result back to the starting cell (which changes each time
the macro is run). I can get it to work but the result always returns to
same range of cells which is not the objective. I always want the result to
return to the starting point.

See Below: when the curser starts under 1/06, the total copys there. When
the curser starts under 1/07, the macro should return under 1/07 and copy
there. But when I run the macro it always returns under 1/06.

totals 1/06 1/07 1/08
3.00 3.00 ***
7.00 7.00
6.00 6.00 *** New total should copy under 1/07
4.00 4.00
20.00 20.00

How do I get the macro to return the result to the starting point?

Thanks for your help
 
D

davemorrison

record your macro in relative mode at the beggining,

you can change from relative to absolute any time when you are
recording a macro,

so... start recording, then press the relative button, if you want to
go to the beggining of a column click a cell in the column and hit
shift up,(if you want to select two from the beggining select shift up
and then down 2, if you want to find the first empty space in a column
select a cell in the column press shift down and then down one),

when you record in absolute mode the actual cell you selected in the
macro will be selected always, relative mode selects the cell in the
action
 
D

damorrison

check your macro, change your paste cell to the correct range.
couldn't you just reference the cell eg: =G7 or do you need that
number to to be absolute?
 
S

sony654

Dave, I am going to launch the macro from a different cell address each time
it runs. I want the macro execution to always complete in the starting cell
(return to it). Thanks - Tom
 
Top