View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve W Steve W is offline
external usenet poster
 
Posts: 2
Default Using offset following an autofilter

I have used the autofilter on one column in my datasheet and i am trying to
select the cell to the right of the first cell in the filtered list.

The filter as it appears in code is:

Selection.AutoFilter field:=field, Criteria1:="<"

I have very little knowledge of VBA and cannot get the offset function to
work on this one. Can you tell me what the next line of code should be to
select the offset cell?