View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 399
Default how to move the pointer in a filtered selection

I set a range to the whole section, apply filters, then reset the range to
the visible cells. This now gives you the freedom to move to (row, column)
within just the filtered range. Something like:
Dim rng As Range
Set rng = Selection 'replace Selection with your range parameters
' Insert filtering here
Set rng = Intersect(rng, rng.SpecialCells(xlCellTypeVisible))
rng.Copy

HTH
Ed

"Alvaro Silva" wrote in message
...
I got a problem, I get a filtered selection in a worksheet, next move is

to
move the pointer in a filtered selection down until it is found a certain
cell empty. That cell is seven columns at right from the active cell
selection.

The filtered seklection has some noncontiguos registers in the DB that is
being modified.

I need to do this in a cycle until it is finished the revision of a

certain
list of lots in another DB.

Alvaro Silva