| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Offset() be used in Excel cell formulas when filtered (visible-only)? | Excel Discussion (Misc queries) | |||
| Offset on a Filtered List | Excel Worksheet Functions | |||
| items filtered | Excel Discussion (Misc queries) | |||
| cut and paste filtered items | Excel Discussion (Misc queries) | |||
| counting filtered items | Excel Worksheet Functions | |||
Linear Mode
