Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect? | Excel Programming | |||
VBA Intellisense | Excel Programming | |||
Intellisense | Excel Worksheet Functions | |||
Copying new activesheet after other activesheet is hidden? | Excel Programming | |||
Sometimes Intellisense, sometimes not | Excel Programming |