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!).

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

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

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