Accessing the Auto List

[xzmike]

How can I (or why can't I) access the auto list in the second example? The first one works fine, but after I put in cells(1).
no auto list.(but if I fill it in myself it works)

Range("a1:a2").Interior.Color = vbRed

Range("a1:a2").Cells(1).

Thanks,
Mike

 

[Barrie Davidson]

Mike, what do you mean by "auto list"? I've never heard that expression before.

 

[Ivan F Moala]

Hi Barry
The autolist feature he refers to is avial
via the VBA editor > Tools > Options >editor
You are probably already using it ? ie
when you type in your syntax (as long as the
word is a recognised object) then placing the
command signal . causes the interprter to
display a list of applicable properties /methods.

 

[Barrie Davidson]

Thanks Ivan, now I know what he means.

 

[Guest]

Don't know why - I think the only way around it is to insert ".Cells(1)" after the rest of the code in that line has been done.