Thread: activesheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim at Eagle Jim at Eagle is offline
external usenet poster
  
Posts: 83
Default 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
Reply With QuoteReply With Quote