Filter by unknown criteria problem

**thornton** · 02-04-2011, 05:33 AM

Hi all,

Please can someone help, can't seem to find a solution for this.

I have a macro set up that organises a filtered list of info, but before I run the macro I need to filter by a room number, which the room number will change every time I use this spread sheet. Is there any way that I can set a macro that will automatically cursor down on the filter list of rooms, rather than selecting a criteria name. I want it to pick the first one in the list, then inbetween each room it selects, another macro is called up.

Thanks

Graham

**JBeaucaire** · 02-04-2011, 12:51 PM

Create a new Range variable based on the visible rows. Then run your macro on each cell in the range, effectively on the row...

Please Login or Register  to view this content.

You used the word "select" and "cursors down" which makes me think your making your macro act on the worksheet the same way you do, which is extremely inefficient. Post your full code and I'm sure we can help speed it up for you.