Hide columns based on autofilter selection

**jj72uk** · 02-28-2011, 10:55 AM

Hi All,

I'm trying to work out a way how to hide cols dependent on autofilter selection but have come to a point in scratching my head.

So far I have this:

Please Login or Register  to view this content.

With a =now() in another cell to trigger the calculation when autofiltering

But it seems to get caught in a never ending loop and can't work out a way forward.

If anyone can help me or suggest an alternative way to code it to hide cols based on autofilters i'd be most greatful

**JBeaucaire** · 02-28-2011, 11:38 AM

Try turning other macros off at the top of this macro so it can proceed to the end without triggering anything else, then turn macros back on again at the end.

Please Login or Register  to view this content.

**jj72uk** · 02-28-2011, 11:53 AM

Hi JB,

Thanks for the reply, thing is this is the only macro within this workbook/sheet.

It physically loops through this marco over and over as when it pastes ....

Ok...mid sentance.. a light bulb has just clicked and I think I have worked it out..

It loops as it continously pastes over and over, thus re-calc each time.

All I've done is change the copy and paste to and activecell.value and there are no calcs.