View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
 
Posts: 390
Default Auto-filter question

In , Dana DeLouis
spake thusly:

Hi. You can select the Headings that will have the drop-down arrows
directly.
Then you can continue with the code. Here's a simple demo you
can test with a blank sheet.

Sub TestIt()
With [A1:AD10]
.Value = "Junk"
.Rows(1) = "Heading"
End With

Range("C1:Y1").AutoFilter
End Sub


Okay, that's helpful. Tomorrow I'll try to see if I can figure
out how to limit the other actions to those columns as well.
Maybe I'll even figure out getting the hide-arrows macro combined
with my other macro, who knows. Thanks again!

Dallman