how to move the pointer in a filtered selection
 

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

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

how to move the pointer in a filtered selection
 

Thanks! Very helpful. Tooks me away from a bog


"Ed" escribió en el mensaje
...
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

how to move the pointer in a filtered selection
 

Well not that good, when run a second attempt that involves a separated area
of the DB, the poniter keeps moving down into the non visible range
regardless of the instruction to show only the visible cells.
That´s annoying because if we do have a noncontiguos area in the DB filtered
in the next attempt to modify we will end modifying registers not intended
to get modifications.

Any idea about what to do?

Alvaro Silva

"Alvaro Silva" escribió en el mensaje
...
Thanks! Very helpful. Tooks me away from a bog


"Ed" escribió en el mensaje
...
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