rename sheet based on values in cells

[Dan88]

Hello, to edit my original post, can anyone help me with a vba on sheet renaming.
I have code to insert sheet, but need the sheet to be renamed based on the data i have in another sheet, "Details", and data in the last row of column B?

Thanks in advance for your help.

 

[Norie]

Why not continue in the original thread?

Or at least inlclude a link to it.

 

[yytsunamiyy]

post your code and a link to your original post please

 

[Dan88]

sorry for the mistake. I thought the original thread was confusing based on wording and didnt know how to edit. Apologies. Here is the link
http://www.mrexcel.com/forum/showthread.php?t=331489

my insert sheet code is in this entry.

Thanks a bunch!