Time Stamp

[Todd Huttenstine]

Hey guys,

What would the code be to make the sheet name of the
active sheet the nmame of the value in cell D1?

For instance if "test" is the value of cell D1, I would
like "test" to be the name of the sheet.


Thanx

Todd Huttenstine

 

[Dave Peterson]

Something like:

on error resume next
with activesheet
.name = .range("d1").value
if err.number <> 0 then
msgbox "couldn't rename"
err.clear
end if
end with

 

[John Wilson]

Todd,

activesheet.name = range("D1").Value

John

 

[Todd Huttenstine]

Thanx to both.