Formula to name Sheets

[rizmomin]

Hello:

I have lots of sheets.
I need to name the sheet by using the variable in cell J1 and K1.
If J1 = Jan and k1 = 01 then need sheet name to be Jan01.

Thanks
Riz

[FDibbins]

You cannot rename sheets with a regulatr formula, you need to use VBA. I will move this to that forum

[1aaaaaaaaaaaaaaa]

For one worksheet

Please Login or Register  to view this content.

For each worksheet in the workbook

Please Login or Register  to view this content.

[rizmomin]

Hi Guys:

Thanks a lot, works for me.

Riz

[1aaaaaaaaaaaaaaa]

Hi Guys:

Thanks a lot, works for me.

Riz

You're welcome