Naming Worksheet after cell values

[kaffal]

I was trying to rename the worksheet. using a cell value,A1. For example , if the cell value is Earning, the worksheet will be named as Earning.

However I would like to include the location before the name, Earning. For example, in the cell value,A2 TK. I would like to rename the worksheet as TK_Earnings.

So the name of the sheet will be CellvalueA1_CellvalueA2.

How can I amend the code to obtain that? Thanks

Please Login or Register  to view this content.

[Andy Pope]

Please Login or Register  to view this content.

[kaffal]

Hi, I guess that will work if both the cell value are from same worksheet.

In my case, from worksheet name Cellvalue1_Cellvalue2,
cellvalue1 is extract from current workbook, cell D3 , while cellvalue2 is extract from the cell A1 in the other workbook.

I have attached the macro I am using

Please Login or Register  to view this content.

[Andy Pope]

I don't do mind reading on Sundays. If you wanted the cell references from different workbooks you should have said.

Please Login or Register  to view this content.