macro horizontal count after filter

**gtg653t** · 12-03-2007, 05:19 PM

hello,

im a newbie with macros. I needed to do a horizontal filter with my data, I did using this design:

http://blog.livedoor.jp/andrewe/archives/50283818.html

but now I need to do a count for each item after the filter is performed, so when a columm is hidden after the filter I need to count how many remain. Any help is greatly appreciated.

**Leith Ross** · 12-03-2007, 10:03 PM

Hello gtg653t,

This macro will return the count of visible columns when the filter is applied. Copy this code and add paste it into Module1 of your project. You can call use this a worksheet function or call inside your VBA code.

Please Login or Register  to view this content.

Example

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**gtg653t** · 12-04-2007, 01:05 AM

Thank You!!!!

macro horizontal count after filter

LinkBack

Thread Tools

Rate This Thread

Display

macro horizontal count after filter

Thanks =)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions