View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] d_lwl@hotmail.com is offline
external usenet poster
 
Posts: 1
Default Cell offset for filtered list

Hi all,

I would like to know the VBA code to move down a row in a filtered
list. I use the ActiveCell.Offset (1,0) method but the cursor moved to
a hidden (set by my filter) row. My current location is A1 (heading for
first column).

I tried lookup for SpecialCells, thinking this may have something to do
with the solution I want. Not succeeding. :(

Thanks for sharing your insights.

David