sheet names

[shrive22]

Is it possible to have assign a sheet name a variable ? or to have the sheet name equal to one of its cells??

thanks

 

[Greg Truby]

You can use VBA to change the sheet name to match a particular cell's value. You can use a formula to extract a sheet's name into the cell. Who's the leader and who's the follower? Does the sheet name determine the cell's contents? Or does the cell's contents determine the sheet's name?

 

[shrive22]

sheet name

What I want to do is have the sheet name automatically update to be equal to a certain cell. Is that possible??

thanks

 

[Greg Truby]

Yes, how familiar are you with VBA? Have you dabbled in the VBE (Visual Basic Editor) some? Or this would be completely new?

 

[shrive22]

sheet name

I have just dabbled in VBE but I was mostly curious if it was possible on the excel front end.

 

[Greg Truby]

No, you cannot have a cell's value update a worksheet name without VBA. Still interested?