Excel 2003 macros set relative cell references

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
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.
 
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
 
JPI

Tools>Customize>Toolbars.

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
 
Dear Gord - thanks for that David

Gord Dibben said:
JPI

Tools>Customize>Toolbars.

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
Click to expand...
 
Back
Top