Making for adding and naming a new sheet
Mine was probably NG wrap-around
Worksheets.Add(after:=Worksheets(ActiveSheet.Index )).Name = _
"Inventory " & Format(DateSerial(Year(Date), _
Month(Date) + 1, 1),"mmmm")
--
HTH
Bob Phillips
(replace somewhere in email address with googlemail if mailing direct)
"michaelberrier" wrote in message
ups.com...
Thanks for the help. Both of those codes return syntax errors I can't
find. Any ideas?
|