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
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