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
 

Post your macro and perhaps someone can help.

Vaya con Dios,
Chuck, CABGx3



"bilbo+" wrote:

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
 

The macro is
Sub addoxy2()
'
' addoxy2 Macro
' Macro recorded 12/07/2007 by
'

'
Rows("44:44").Select
Selection.Insert Shift:=xlDown
Selection.Insert Shift:=xlDown
Range("C42:J42").Select
Selection.Copy Destination:=Range("C44:J44")
Range("E44").Select
End Sub

hope that helps

"CLR" wrote:

Post your macro and perhaps someone can help.

Vaya con Dios,
Chuck, CABGx3



"bilbo+" wrote:

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
 

Maybe this will work, or be something you can modify..........

Sub addoxy()
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Range("$C$42:$J$42").Copy
ActiveSheet.Paste
ActiveCell.Select
Selection.Offset(0, 2).Select
End Sub

Vaya con Dios,
Chuck, CABGx3



"bilbo+" wrote:

The macro is
Sub addoxy2()
'
' addoxy2 Macro
' Macro recorded 12/07/2007 by
'

'
Rows("44:44").Select
Selection.Insert Shift:=xlDown
Selection.Insert Shift:=xlDown
Range("C42:J42").Select
Selection.Copy Destination:=Range("C44:J44")
Range("E44").Select
End Sub

hope that helps

"CLR" wrote:

Post your macro and perhaps someone can help.

Vaya con Dios,
Chuck, CABGx3



"bilbo+" wrote:

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