ActiveSheet.Name = Range("e1").Value & Range("F1").Value

ActiveSheet.Name = Range("e1").Value & "test"

--
HTH

Bob Phillips

"Darin Kramer" wrote in message
...
Howdie,

Basic VBA for renaming a sheet with value in cell e1 is:
ActiveSheet.Name = Range("e1").Value

Two sitns I want to:
a) rename sheet with say e1 and f1, and for a different sheet
b) rename sheet with e1 and the word test

any ideas..?

Thanks

D



*** Sent via Developersdex http://www.developersdex.com ***