The IntelliSense is Excel works sometimes, and doesn't other times.
This works every time:
But when I type this, I get some help from Excel:
I keep typing, but then [tt]cells(1, 1).[/tt] dosn't give me any hints after the period
when I want to have: [tt]Cells(1, 1).[blue]Value[/blue][/tt] for example
The same when I want to use [tt]UsedRange[/tt] of the [tt]ActiveSheet[/tt]
So I type:
[tt]activesheet.[/tt] - no help from IntelliSense
[tt]activesheet.usedrange.[/tt] - no help from IntelliSense
[tt]activesheet.usedrange.rows[/tt] - no help from IntelliSense
[tt]activesheet.usedrange.rows.count[/tt]
but then, at the end , I do get:
[tt]ActiveSheet.UsedRange.Rows.Count[/tt]
with all capitalized letters and it works OK
What am I missing...![[ponder] [ponder] [ponder]](/data/assets/smilies/ponder.gif)
---- Andy
"Hmm...they have the internet on computers now"--Homer Simpson
This works every time:

But when I type this, I get some help from Excel:

I keep typing, but then [tt]cells(1, 1).[/tt] dosn't give me any hints after the period
when I want to have: [tt]Cells(1, 1).[blue]Value[/blue][/tt] for example
The same when I want to use [tt]UsedRange[/tt] of the [tt]ActiveSheet[/tt]
So I type:
[tt]activesheet.[/tt] - no help from IntelliSense
[tt]activesheet.usedrange.[/tt] - no help from IntelliSense
[tt]activesheet.usedrange.rows[/tt] - no help from IntelliSense
[tt]activesheet.usedrange.rows.count[/tt]
but then, at the end , I do get:
[tt]ActiveSheet.UsedRange.Rows.Count[/tt]
with all capitalized letters and it works OK
What am I missing...
![[ponder] [ponder] [ponder]](/data/assets/smilies/ponder.gif)
---- Andy
"Hmm...they have the internet on computers now"--Homer Simpson