Now, that is pseudo code.

--
Don Guillett
SalesAid Software

"Johnny" wrote in message
...
I have the code below to rename a tab based on a cell contents in that
worksheet. They only way to get the tab to rename is to change the cell
contents. That's fine but the cell is referencing another worksheet and
when
I change that cell, the tab I need changed does not rename.