Copying named cells

[amzma]

Hi there

I have a spreadsheet that I use to keep helpful formulas in for work that I need to do.

I have made two buttons that calculate two different cells but a specific number, when I am copying it into other workbooks the buttons arent working as it is copying the cells names, for example B18 I have renamed "osi" but when I copy it into a new sheet it reverts back to "b18", is there anyway to keep the name I have made?

Here is the VBA code I have made below;

Sub Macro1()
'
' Macro1 Macro
'

'
Range("owe").Select (this is normally cell B18)
ActiveCell.FormulaR1C1 = "=SUM(R[-5]C*77.5)"
Range("owe").Select
End Sub

Sub Macro2()
'
' Macro1 Macro
'

'
Range("osi").Select (this is normally cell B19)
ActiveCell.FormulaR1C1 = "=SUM(R[-6]C*45)"
Range("osi").Select
End Sub

Any help will be greatly appreciated!

Many thanks.
Amy

 

[davesexcel]

Here is a thread on copying named ranges.

How to Move/Copy Named Ranges of one workbook to another with VBA

Gurus, is it possible to insert the specific named ranges of one workbook to another workbook using VBA? for example i have workbook named ("Book1") in which my named ranges are and i want to copy named range DynRngAcc and DynRngProd to another workbook ("Book2"). any help is...

www.mrexcel.com

 

[amzma]

Here is a thread on copying named ranges.

How to Move/Copy Named Ranges of one workbook to another with VBA

Gurus, is it possible to insert the specific named ranges of one workbook to another workbook using VBA? for example i have workbook named ("Book1") in which my named ranges are and i want to copy named range DynRngAcc and DynRngProd to another workbook ("Book2"). any help is...

www.mrexcel.com

Hi Dave

Thank you for the info, is there a way to copy it without having to manually change the "workbook2" name each time as I copy it into lots of different sheets, all with different names.

Thanks.
Amy