Ignore Filtered items in actvecell.offset

C

CLS

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

Chad
 
C

Chip Pearson

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
 
N

N10

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

Chad
Click to expand...

Chad what do mean skip over ?

What are trying to achieve ?

N10
 
Top