Hi
I got this macro from someone else, but realised it does the complete opposite of what i want!
I want to only show the columns (so usually width of 64 pixels) and reduce the column width of everything else to 0Please Login or Register to view this content.
This code reduces the column width of the cells i want to see to 0
My value is in cell H1 and if it says "kiwi" i want it to show all columns from b7 onwards horizontally that contain kiwi, again this does the opposite.
Hopefully someone could help me out?
Cheers
Dan
Bookmarks