Copy/Paste Defined NAMEs

[PIJim]

I am using Excel 2007

I am creating reports where I have to define NAMES for several cells & cell ranges.

I will need to repeat this process numerous times within the same sheet and on additional sheets. The only thing that will change in the NAMES are the cell references and references to defined NAMES.

Is there a way I can copy/paste names? This would save me a bunch of time if I only had to modify small parts of the NAME definitions.

Thanks for any help
Jim

 

[crook_101]

Hi,

Sub Paste() 
Application.Goto Reference:="HEADER" 'adjust for your named ranges
Selection.Copy
Sheets("Sheet2").Select 'adjust for your target
Range("A7").Select 'adjust for your target
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

Regards,
Ian

 

[PIJim]

Thanks

Is there a way to do it without code?

 

[PIJim]

I tried the code and couldn't get it to work. I know very little about VBA

Can you explain the logic of this code so I cant attempt to figure out what I am doing wrong?

Thank you
Jim