Rename sheets names according cell's values: how to handle errors produced by empty cells

[Lalla]

Hi,

I'm trying to modify the following Vba istructions.

In cells G7 and H3 I have to write different names of nations, but if I delete the contents of cells G7 and H3, I would like to handle the error by renaming again the sheets with the original name (Sheet2 and Sheet7),

Please Login or Register  to view this content.

I hope my poor English (and very poor description) could be clear.

Regards

[HaHoBe]

funny forum

Please Login or Register  to view this content.

I would not rely on the position of the sheeets in the workbook but refer to the codenames instqead no matter what the sheets are called.

Ciao,
Holger

[Lalla]

Hi Holger

I'm studying Vba "copying and studying" little examples I'm finding Googling around.


Thank you much.