Accessing the Auto List

xzmike · Feb 16th, 2002, 11:39 AM

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 · Feb 16th, 2002, 11:59 AM

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

Ivan F Moala · Feb 16th, 2002, 02:32 PM

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 · Feb 16th, 2002, 05:54 PM

Thanks Ivan, now I know what he means.

Feb 17th, 2002, 01:56 AM

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.

Feb 16th, 2002, 05:54 PM	#4
Barrie Davidson MrExcel MVP Join Date: Feb 2002 Location: Winnipeg Posts: 2,330	Thanks Ivan, now I know what he means. __________________ Barrie Davidson "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 16th, 2002, 11:39 AM	#1
xzmike Board Regular Join Date: Feb 2002 Posts: 110	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

Feb 16th, 2002, 11:59 AM	#2
Barrie Davidson MrExcel MVP Join Date: Feb 2002 Location: Winnipeg Posts: 2,330	Mike, what do you mean by "auto list"? I've never heard that expression before.

Feb 16th, 2002, 02:32 PM	#3
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	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.

Feb 17th, 2002, 01:56 AM	#5
Guest Posts: n/a	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.