I need to edit the following to allow a user to pick from multiple columns, not just column A and still have it hide and unhide blank columns. Example: User filters column A, this code works perfrectly, but I need the code to work if a users filters column A or D or J as an example.
Please Login or Register to view this content.
Perhaps if you lose the one?
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
I think you'd need to loop through the filtered columns.
Something like:
Please Login or Register to view this content.
but where you go from there ...
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks