I'm new to VB 6.0. I want help writing a macro to rename an existing Excel
worksheet using a value that is contained in a cell on another worksheet in
the same workbook.

If I use:
worksheets("sheet1").name=MonthName(1,1) the sheet is renamed JAN.
However if I use:
....MonthName("report_month",1) where "report_month" (with or without
quotation marks) refers to a cell that contains the number 1, I get zip.

If I use an message box to display the value of "report_month", the box
displays the location of the cell named "report_month".

How can I get MonthName to recognize the VALUE of the contents of "R-M"?

Many thanks.

Possibly

Sheets("Sheet1").Name = Range("A1").Value

Mike

"JTE and ECJT" wrote:

I'm new to VB 6.0. I want help writing a macro to rename an existing Excel
worksheet using a value that is contained in a cell on another worksheet in
the same workbook.

If I use:
worksheets("sheet1").name=MonthName(1,1) the sheet is renamed JAN.
However if I use:
....MonthName("report_month",1) where "report_month" (with or without
quotation marks) refers to a cell that contains the number 1, I get zip.

If I use an message box to display the value of "report_month", the box
displays the location of the cell named "report_month".

How can I get MonthName to recognize the VALUE of the contents of "R-M"?

Many thanks.

Mike - sorry that it took so long to get back to you. I thought that I had
set up auto notification of replies but must not have done so.

Thanks - I'll give your solution a try. It makes sense to me.

"Mike H" wrote:

Possibly

Sheets("Sheet1").Name = Range("A1").Value

Mike

"JTE and ECJT" wrote:

I'm new to VB 6.0. I want help writing a macro to rename an existing Excel
worksheet using a value that is contained in a cell on another worksheet in
the same workbook.

If I use:
worksheets("sheet1").name=MonthName(1,1) the sheet is renamed JAN.
However if I use:
....MonthName("report_month",1) where "report_month" (with or without
quotation marks) refers to a cell that contains the number 1, I get zip.

If I use an message box to display the value of "report_month", the box
displays the location of the cell named "report_month".

How can I get MonthName to recognize the VALUE of the contents of "R-M"?

Many thanks.