View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peters Peters is offline
external usenet poster
 
Posts: 18
Default How to make the first cell in autofiltered list the activecell?


Hi,

I have a list of data that I autofilter to show only one row. From this row
I want to assign data to variables with the attached code.

My problem is that the active cell is never in my autofiltered list and I do
not seem to be able to get it there. How do I get a fix reference (such as
the active cell) on the only visible row in a fixed column?

Please help,
Peter

Selection.AutoFilter Field:=3, Criteria1:=myReqRev

' How do I change the activecell to be on the only and/or first visible row?

With ActiveCell
myReqSourceID = .Offset(0, 0).Value
myReqText = .Offset(0, 1).Value
myValue = .Offset(0, 2).Value
myUnit = .Offset(0, 3).Value