VBA Editor not autocompleting

[eduzs]

Why is my VBA Excel editor not autocompleting while I type the code?
For example: if I type "Selection". I'll usually expect to see the list of things I can do with it.
Maybe I disabled any setting?

Thanks

 

[Fluff]

He says that it returns a Varient

the _Default property returns a Variant type – not a Range object type – and that when you type Sheet1.Cells(1,1) into the VBA IDE it is a short-hand way of writing Sheet1.Cells.[_Default](1,1).

 

[shg]

I read that. But if it's always Variant/Object/Range, why not just return a Range object?

 

[Fluff]

I've absolutely no idea.