Rename worksheet based on content in Cell C3

Hi All,

My code is as below

Please Login or Register  to view this content.

Is there anyway i can rename the the current worksheet with the content in Cell C3?

Regards,

i got this code from the Marco I recorded.

I am puzzled by this sentence of coding

Please Login or Register  to view this content.

When I remove the 'Offset(-24,-2), the whole marco will not work.

For my end product, I want to copy the selected cells,from A1 to C28, in 'main.xls', to a newly created sheet in 'Project Database.xls'.

I managed to rename the sheet.

Please Login or Register  to view this content.

Yes. These are from my recorded marco.. ;-)

the code you provided failed at

Please Login or Register  to view this content.

My inital thinking was that the 'copied' items have not been 'pasted' yet, so it's a empty cell. I tried to shift the

Please Login or Register  to view this content.

above the code, but it still fails.

is it that I need to set the new sheet as active, then i do a 'paste' then i rename my sheet based on C3 ?

I can see that it added a new sheet in the project database.xls

fail at

Please Login or Register  to view this content.

Error Code: object does not support this property or method

I skip this step, it fails at the naming part. This i assume is because the cell is empty..

i look through excel help file and found this code

Please Login or Register  to view this content.

But how do i point 'sheet1' as the newly created sheet?

Hi Roy,

I change it to

Please Login or Register  to view this content.

Somehow 'Paste' doesn't work on my side..

Anyway, thanks