Ignore Filtered items in actvecell.offset

  • Thread starter Thread starter CLS
  • Start date Start date
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
 
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 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to use cells as a autofilter 0
Using Filter List to set Chart Symbol, data labels etc 1
Filtering Data 1
select all (including hidden) rows in autofilter region 2
array-to-row autofilter issue 3
help with highlight code 4
Autofilter based on user inputbox 3
Copy and paste 1

Back
Top