Name Worksheet
Just remember to find the sheet that's CURRENTLY named "remaining" and change
it's name first.
--
"Actually, I *am* a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
"Mike H" wrote:
hi,
When you add a sheet it becomes the activesheet so use that
Worksheets.Add
ActiveSheet.Name = "Remaining"
Mike
"MCheru" wrote:
I have a macro that creates a new worksheet when I run it. The given name
could be Sheet 1, Sheet 2, Sheet 3, etc. The point is that I never know what
number Sheet the macro will give the worksheet because it changes each time I
run it. I want to create a code that will find the worksheet with Sheet in
the name and change the name of the worksheet to Remaining. Here is what I
have so far.
newsht.Name = "Remaining"
|