View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MakeLei MakeLei is offline
external usenet poster
 
Posts: 47
Default Can I address in autofilter FIELD with a value in a cell?

Hi,
Is there a possibility to use other than FIELD:=41 in row below?
Selection.AutoFilter Field:=41, Criteria1:="defined values"

What I have in mind is that I would like to be able to define the heading
cell value and use filtering in that column.

All comments and adise is valuable. Thanks in advancd