Thread
:
Changing range names in VBA
View Single Post
#
4
Posted to microsoft.public.excel.programming
Rob Slagle[_2_]
external usenet poster
Posts: 4
Changing range names in VBA
How about some code to loop through all of the defined range names and
add the variable at the end and delete the old names, to where I don't
have to program each name one by one?
(Rob Slagle) wrote in message om...
Thanks alot for your help, this is going to help me get alot done.
"Tom Ogilvy" wrote in message ...
Range("Lae4").Name = "Lae4" & "_" & Cell.Value
ActiveWorkbook.Names("Lae4").Delete
--
Regards,
Tom Ogilvy
"Rob Slagle" wrote in message
m...
I have a worksheet that a 3rd party Excel application will populate
with data.
ie. the application will generate 5 files with an excel template.
the application will populate a certain cell with a value.
I want to take an existing range name on the sheet after the file is
generated and add an "_" and the value of the that certain cell that
got populated.
ie. existing range name = "lae4" cell value = "AL"
result desired is the range name would be "lae4_AL" and that the
"lae4" range name would be deleted.
Any ideas?
Rob
Reply With Quote
Rob Slagle[_2_]
View Public Profile
Find all posts by Rob Slagle[_2_]