Hi,
but I need this macro to work in every new sheet created, thus I can't put
in a specific "worksheet" name. I tried using "ActiveSheet" instead but it
doesn't work. Please help!
myAdjName = Format(ActiveSheet.Range("A1").Value, "mmm") & "(ADJ)"
ActiveSheet.Name = myAdjName
Thanks,
Val.
"HiArt" wrote:
Hi Dolphinv4,
I have had the same problem with Range, the macro looks like it should
work, but doesn't.
The solution is that Range sometimess needs to be in the format
-expression-.range. For your macro try:
myAdjName = Format(*Worksheets(1).*Range("A1").Value, "mmm") & "(ADJ)"
Adjust the Worksheets(x) value accordingly.
HTH
Art
--
HiArt
------------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953
View this thread: http://www.excelforum.com/showthread...hreadid=472032