Hello guys
I need help. I am trying to write my first VBA code. First complicatio
has already occured :-).
I want to name the list after cell, including cell´s forma
(00"/"0000"/"00)

I use this simple code but doesn´t work properly:

Private Sub CommandButton2_Click()
ActiveSheet.Name = ActiveSheet.Range("B1").Value
End Sub



For instance: The cell has content : 05/4103/01 and I need to get thi
into List´s name field.

My procedure returns only 5410301 as a List name


Thank you for your advice

--
Toma
-----------------------------------------------------------------------
Toman's Profile: http://www.excelforum.com/member.php...fo&userid=3139
View this thread: http://www.excelforum.com/showthread.php?threadid=51479