Changing range names in VBA

  • Thread starter Thread starter Rob Slagle
  • Start date Start date
R

Rob Slagle

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
 
Range("Lae4").Name = "Lae4" & "_" & Cell.Value

ActiveWorkbook.Names("Lae4").Delete
 
Thanks alot for your help, this is going to help me get alot done.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Named Range maker code 9
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Copy value from changing cells without VBA 1
Code in Excel 2000 template doesn't work in Excel 2010 1
Dynamic Nammed Range 5
Named Ranges in various sheets 1
Name the range AFTER copied to new sheet 6

Back
Top