Naming sheets by using last filled in cell in column

[mlint]

Hello,

I am currently working on a spreadsheet with a lot of worksheets and I want these worksheets to be named by referring to the last filled in cell in the "C" column.

Please Login or Register  to view this content.

As you can see the formula is now using the the cell C2 as the name for the sheet, but that should be te last filled in sheets in column C. Thanks in advance.

Regards,

Marald

[AB33]

What is the use of the counter?

Please Login or Register  to view this content.

[mlint]

First off, thanks for your quick reply! I do not know what the counter is for, I did not create the code myself.

I just have one more question regarding this code, I keep getting an error if the sheetname is already in use. How can I adjust the code so that no error occurs anymore.

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.

[HaHoBe]

Hi, John,

your code will not consider that the sheet name might already being used and raise a RTE.

@mlint:
maybe try either of these code codes and see if they do what you want:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ciao,
Holger

[AB33]

My code is wrong anyway. It returns the last row which is long, not the last value.
Holger's code is right and use it.