Why no intellisense for ActiveSheet

  • Thread starter Thread starter mp
  • Start date Start date
M

mp

this code works, but when i put a . after ActiveSheet
I don't get UsedRange (or anything at all) in intellisense to show me what's
available

Debug.Print Application.ActiveSheet.UsedRange.Rows.Count

if i do
Set oWs = Application.ActiveSheet
Debug.Print oWs.UsedRange.Rows.Count
I do get intellisense....
no big deal, just wondering why

thanks
mark
 
The activesheet could be a worksheet, a chart sheet, a macro sheet, a dialog
sheet...

That's the reason I use a variable that's declared nicely (like you did!).
 
Oh! I see.
Thanks

Dave Peterson said:
The activesheet could be a worksheet, a chart sheet, a macro sheet, a
dialog sheet...

That's the reason I use a variable that's declared nicely (like you did!).
Click to expand...
 
Back
Top