Rename of worksheet question

  • Thread starter John D. Inkster
  • Start date
J

John D. Inkster

I have a time card that I created and want to take the name from one of the
cells that is in a vlookup table, and use that name to add a new worksheet
with that name. When I record the macro it uses the name that is in the cell
originally, but when I run the macro it still uses the same name as the
first time? Is there a way of qualifying that I want the "current value" not
the original name in the cell as the name for the worksheet?

Thanks in advance

John
 
P

Paul B

John, try something like this,

Worksheets.Add.Name = Sheets("Sheet1").Range("A1").Value


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top