A arwhitley Nov 10, 2004 #1 I appreciate the help, but I'm not sure where to put you recommendation. Which object and procedure do I use
I appreciate the help, but I'm not sure where to put you recommendation. Which object and procedure do I use
F Frank Kabel Nov 10, 2004 #2 Hi you need VBA. This is some part of a macro procedure. Without VBA no chance
G Gord Dibben Nov 10, 2004 #3 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
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
