Recording macros for multiple copying and paste it always goes back to the
original cell reference not the subequent cell. Can anybody help stop going
back to original absolute cell reference

Well it depends how you are using it. Can you explain a little bit more?

Because you can use

ActiveCell.Offset(x,y).Copy

So if you want to copy a cell, then go to the cell below it... you would say

ActiveCell.Copy
ActiveCell.Offset(1,0).PasteSpecial

Or there are numerous other ways, but I'd have to know the order of the
copying, like if you press a shortcut key, or if all the data aligned... etc.

"JPI" wrote:

Recording macros for multiple copying and paste it always goes back to the
original cell reference not the subequent cell. Can anybody help stop going
back to original absolute cell reference

Oh yea, another thing you can do is... when you are recording the macro,
there should be a little box with a stop button and a little thing next to
it. Click that thing next to the stop button, that will give you a code with
relative references rather then absolute.

"JPI" wrote:

Recording macros for multiple copying and paste it always goes back to the
original cell reference not the subequent cell. Can anybody help stop going
back to original absolute cell reference

Thanks - this is what I thought was supposed to happen, but when I am
recording the macro there are no boxes/toolbars or similar. To stop the
recording I have to go Tools/Macros/Stop Recording - so I don't have the
option to manage the absolute/relative cell references. Can you advise how I
can fix this up. Thanks David

"AKphidelt" wrote:

Oh yea, another thing you can do is... when you are recording the macro,
there should be a little box with a stop button and a little thing next to
it. Click that thing next to the stop button, that will give you a code with
relative references rather then absolute.

"JPI" wrote:

Recording macros for multiple copying and paste it always goes back to the
original cell reference not the subequent cell. Can anybody help stop going
back to original absolute cell reference

hmm... im sure I could figure it out if excel was in front of me, but I'm on
a community computer at my workplace dorms and excel isn't installed on it.
But if you can explain to me what you cut and where you paste it, I can help
you out.

Research ActiveCell, Offset, End, and Cells.

Using combinations of those above, you can easily tell excel to move
anywhere you want.

"JPI" wrote:

Thanks - this is what I thought was supposed to happen, but when I am
recording the macro there are no boxes/toolbars or similar. To stop the
recording I have to go Tools/Macros/Stop Recording - so I don't have the
option to manage the absolute/relative cell references. Can you advise how I
can fix this up. Thanks David

"AKphidelt" wrote:

Oh yea, another thing you can do is... when you are recording the macro,
there should be a little box with a stop button and a little thing next to
it. Click that thing next to the stop button, that will give you a code with
relative references rather then absolute.

"JPI" wrote:

Recording macros for multiple copying and paste it always goes back to the
original cell reference not the subequent cell. Can anybody help stop going
back to original absolute cell reference

Thanks - here goes for example:
Have a cell (say c3) want to copy it one cell to the right (d4) then cut
that cell (d4) and paste one to the right (e4) then repeat the process of the
result in e4 again about 10 times. Want to do this sevral times on several
rows in different sheets and different files (does that make sense?) Thanks

"AKphidelt" wrote:

hmm... im sure I could figure it out if excel was in front of me, but I'm on
a community computer at my workplace dorms and excel isn't installed on it.
But if you can explain to me what you cut and where you paste it, I can help
you out.

Research ActiveCell, Offset, End, and Cells.

Using combinations of those above, you can easily tell excel to move
anywhere you want.

"JPI" wrote:

Thanks - this is what I thought was supposed to happen, but when I am
recording the macro there are no boxes/toolbars or similar. To stop the
recording I have to go Tools/Macros/Stop Recording - so I don't have the
option to manage the absolute/relative cell references. Can you advise how I
can fix this up. Thanks David

"AKphidelt" wrote:

Oh yea, another thing you can do is... when you are recording the macro,
there should be a little box with a stop button and a little thing next to
it. Click that thing next to the stop button, that will give you a code with
relative references rather then absolute.

"JPI" wrote:

Recording macros for multiple copying and paste it always goes back to the
original cell reference not the subequent cell. Can anybody help stop going
back to original absolute cell reference

JPI

ToolsCustomizeToolbars.

Select the Stop Recording Toolbar.

Start Recording a macro then hit the Stop button.

DO NOT hit the "x" to stop or you will lose the Toolbar again.


Gord Dibben MS Excel MVP


On Sun, 20 May 2007 19:22:01 -0700, JPI wrote:

Thanks - this is what I thought was supposed to happen, but when I am
recording the macro there are no boxes/toolbars or similar. To stop the
recording I have to go Tools/Macros/Stop Recording - so I don't have the
option to manage the absolute/relative cell references. Can you advise how I
can fix this up. Thanks David

"AKphidelt" wrote:

Oh yea, another thing you can do is... when you are recording the macro,
there should be a little box with a stop button and a little thing next to
it. Click that thing next to the stop button, that will give you a code with
relative references rather then absolute.

"JPI" wrote:

Recording macros for multiple copying and paste it always goes back to the
original cell reference not the subequent cell. Can anybody help stop going
back to original absolute cell reference

Dear Gord - thanks for that David

"Gord Dibben" wrote:

JPI

ToolsCustomizeToolbars.

Select the Stop Recording Toolbar.

Start Recording a macro then hit the Stop button.

DO NOT hit the "x" to stop or you will lose the Toolbar again.


Gord Dibben MS Excel MVP


On Sun, 20 May 2007 19:22:01 -0700, JPI wrote:

Thanks - this is what I thought was supposed to happen, but when I am
recording the macro there are no boxes/toolbars or similar. To stop the
recording I have to go Tools/Macros/Stop Recording - so I don't have the
option to manage the absolute/relative cell references. Can you advise how I
can fix this up. Thanks David

"AKphidelt" wrote:

Oh yea, another thing you can do is... when you are recording the macro,
there should be a little box with a stop button and a little thing next to
it. Click that thing next to the stop button, that will give you a code with
relative references rather then absolute.

"JPI" wrote:

Recording macros for multiple copying and paste it always goes back to the
original cell reference not the subequent cell. Can anybody help stop going
back to original absolute cell reference