Accessing the Auto List
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Accessing the Auto List

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    110
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  5. #5
    Guest

    Default

      
    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com