Macro paste into sheet name

[tkuia]

Hi,
I recorded a macro and wanted to copy and paste into the sheet name.
I got:

Please Login or Register  to view this content.

I don't want to always copy "20110828", but to paste what C1 has.
How can I do that?
Tnx!
T.

[SOS]

Hi tkuia,

Firstly you have to qualify which Sheet Range C1 comes from but then you have no need to Select anything. Just use:

Please Login or Register  to view this content.

But if it is the current Sheet you want to rename then

Please Login or Register  to view this content.

[tkuia]

Very good! thank you.
What if I don't know the current sheet name?
Because I am using : " Sheets.Add After:=Sheets(Sheets.Count) "
And this gives me different sheet name every time.
Or... How can I open new sheet with known name?

[SOS]

Hi,

As soon as you add a new sheet it becomes the Active Sheet so therefore

Please Login or Register  to view this content.

Bur be aware that if you run this more than once it errors telling you that you already have a sheet called "Whatever".

Not quite sure how to deal with that part