Why no intellisense for ActiveSheet
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 |
Why no intellisense for ActiveSheet
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!). On 02/05/2011 16:39, mp wrote: 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 -- Dave Peterson |
Why no intellisense for ActiveSheet
mp explained :
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 Mark, That's just "the nature of the beast".<g You'll always get intellisense using explicit object refs in this context (just as you did here using 'oWs'). Not all global objects provide intellisense for the reasons Dave cites. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Why no intellisense for ActiveSheet
Oh! I see.
Thanks "Dave Peterson" wrote in message ... 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!). On 02/05/2011 16:39, mp wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 02:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com