Time Stamp

T

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
 
D

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
 
Top