Posted to microsoft.public.excel.programming

moonhk[_2_] moonhk[_2_] is offline

external usenet poster

Posts: 36

How to check row is hidden when apply filter

Hi All

For Excel 2003
When Apply Filter , How to check the row have been filtered out ?

Below coding include filtered out row.

iRows = Application.Selection.Rows.Count
iCols = Application.Selection.Columns.Count

For ir = 1 To iRows
.....
Next

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
msg box to apply filter	Kirsty	Excel Programming	3	May 19th 09 11:31 AM
Apply same filter to all sheets in a workbook	manfareed	Excel Programming	9	July 31st 08 03:34 PM
Apply format with check box	Luis A. Vázquez	Excel Programming	1	October 16th 07 03:39 PM
Apply Auto Filter on One Column	Bill Foley	Excel Programming	5	March 2nd 07 10:16 AM
Macro or VB to apply filter in spreadsheet	Stevie[_3_]	Excel Programming	2	February 18th 04 03:15 PM

All times are GMT +1. The time now is 01:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us