Setting Worksheet Name = to Cell in Worksheet

A

arwhitley

I appreciate the help, but I'm not sure where to put you
recommendation. Which object and procedure do I use
 
G

Gord Dibben

Sub SheetName()
ActiveSheet.Name = Range("A1")
End Sub


If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module. Paste the above code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Hit ALT + F8 and select the macro. Run it.

Gord Dibben Excel MVP
 
Top