option selection -VBA

[grk_chakri]

Hello All

How do i know what option should we use with the option "SELECTION" when i am writing a vba code.

For example i could write something like this

Selection.Interior.Pattern = xlSolid

But after i type the word selection there are no options generated
where can i get a list what can be used with that word "SELECTION"
in vba code.

Also this xlsolid, xlautomatic... where can i get the list and its features

thanx for your time

 

[shg]

A selection can be anything (a range, a chart, an autoshape, ...) each of which have different properties and methods, so there's no way for IntelliSense to work.

There is rarely a need to select anything, and your code will run faster if you don't.