Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activesheet
""" sheet2 is active at this pt """" then the following code
Sheets.Add After:=Sheets(3) ActiveSheet.Name = this_no Range("A1").FormulaR1C1 = this_no Why would line 3 place "this_no" on sheet2 -- Jim at Eagle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get ActiveSheet name in VB | Excel Programming | |||
name of the activesheet | Excel Programming | |||
ActiveSheet.Name? | Excel Programming | |||
ActiveSheet | Excel Programming | |||
ActiveSheet | Excel Programming |