Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and determining which sheet the code is running under
Hi
I am calling code that resides within different sheets. So I start on sheet1 and press a go button the go button calls a function on sheet2, sheet3 etc. Within the code on sheet2 I need to grab the name of sheet2. I cannot hard code it as the sheets maybe renamed and I need the current sheet name. I have tried using ActiveSheet but this returns sheet1. Any ideas? thanks Jake |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
determining running counts | Excel Worksheet Functions | |||
running code | New Users to Excel | |||
Determining the Selection on a non-active Sheet? | Excel Programming | |||
Running Code on Each Sheet in an Excel Workbook | Excel Programming | |||
running VB code | Excel Programming |