Thread: copying cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bilbo+ bilbo+ is offline
external usenet poster
 
Posts: 11
Default 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