Ignore Filtered items in actvecell.offset
 

Is there a way to setup the ActiveCell.offset(x,y).Activate command skip
over rows that are hidden due to an autofilter?

Chad

Ignore Filtered items in actvecell.offset
 

Chad,

No, you can't have Offset ignore hidden rows. You'll have to
loop, testing each row's Hidden property.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"CLS" remove NOT wrote in message
...
Is there a way to setup the ActiveCell.offset(x,y).Activate
command skip
over rows that are hidden due to an autofilter?

Chad

Ignore Filtered items in actvecell.offset
 

"CLS" remove NOT wrote in message
...
Is there a way to setup the ActiveCell.offset(x,y).Activate command skip
over rows that are hidden due to an autofilter?

Chad



Chad what do mean skip over ?

What are trying to achieve ?

N10