Hi Toman
The slash (/) is not a legal sheet name character.
Changing the slash for (say) a hyphen, your code worked for me.
---
Regards,
Norman
> Hello guys
> I need help. I am trying to write my first VBA code. First complication
[quoted text clipped - 14 lines]
>
> Thank you for your advices
Norman Jones - 21 Feb 2006 09:47 GMT
Hi Toman,
> Changing the slash for (say) a hyphen, your code worked for me.
Or, more explicitly:
ActiveSheet.Name = _
Format(ActiveSheet.Range("B1").Value, "00-0000-00")
---
Regards,
Norman
Toman - 21 Feb 2006 10:37 GMT
Thank you guys.
Now it is working perfectly;)

Signature
Toman