Controlling Hidden Rows / Columns in Filtered List

KC VBA Qns

Guest

Posts: n/a

29th Dec 2006

Hi,

I have always wanted in vain to set 3 filter conditions within same
field but never quite succeeded. Is there a way to set it
programmatically?

In Excel environment, highlighting a portion of a filtered list
actually automatically includes the hidden rows and columns. To
eliminate this we could choose only visible cells. In VBA environment,
highlighting a portion of a filtered list actually automatically
EXCLUDES the hidden rows and columns. How could I include the hidden
rows and columns??

Rgds,

« Macro Help | Problem with ATPVBAEN.XLA »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copying one column with hidden/filtered rows to another colum	Rechie	Microsoft Excel Misc	2	14th Sep 2009 06:28 PM
how do i paste rows/columns avoiding hidden rows/columns	perezli	Microsoft Excel Misc	1	30th Jan 2009 03:58 PM
How do I display a list of the rows or columns that I've hidden?	indyogden	Microsoft Excel Misc	1	29th Jan 2009 05:12 AM
hidden/filtered rows	=?Utf-8?B?TWlrZQ==?=	Microsoft Excel Misc	0	19th Apr 2006 10:30 PM
Unique Count sensitive to hidden/filtered rows	=?Utf-8?B?SWFu?=	Microsoft Excel Worksheet Functions	7	12th May 2005 08:58 PM