copying cells
 

Hi there, I've created a macro at the top of a page that inserts two rows and
copys some text from above, to create another 'entry' but ive also done this
further down but after ive run the top one it then puts the bottom one out of
sync, is there any way of making a macro relative to a certain cell or
relative to the button that runs it? or any solution will do... i just need
to be able to replicate bits of text to create room for more entries at
different stage down the page, help much appreciated¬!
thanks
Will

copying cells
 

If you recorded a macro you probably got references hard wired to specific
cell addresses. Typically you want utility macros to run off of the active
cell or selection, so you'd replace specific cell references with ActiveCell
or Selection. Can't say any more without your actual code.

--
Jim
"bilbo+" wrote in message
...
Hi there, I've created a macro at the top of a page that inserts two rows
and
copys some text from above, to create another 'entry' but ive also done
this
further down but after ive run the top one it then puts the bottom one out
of
sync, is there any way of making a macro relative to a certain cell or
relative to the button that runs it? or any solution will do... i just
need
to be able to replicate bits of text to create room for more entries at
different stage down the page, help much appreciated¬!
thanks
Will