Hello - I need help in creating macros which will hide specific columns in a worksheet -not just by reference.
For instance, if i had a worksheet with the headers 'apples' 'oranges' 'bananas' 'hamburgers' 'hot dogs' etc. and macro buttons on the top that state 'SHOW COLUMNS of FRUIT only' and 'SHOW COLUMNS of MEAT only'. The way I have it now - I have set macros up manually to hide specific columns - but if you add additional columns in between, it skews the macro results. Can a macro be created to list the names of the column headers so wherever they are moved - the macro will still identify it and hide or unhide it? this may be an Excel 101 question - but not for me.
Thanks..
For instance, if i had a worksheet with the headers 'apples' 'oranges' 'bananas' 'hamburgers' 'hot dogs' etc. and macro buttons on the top that state 'SHOW COLUMNS of FRUIT only' and 'SHOW COLUMNS of MEAT only'. The way I have it now - I have set macros up manually to hide specific columns - but if you add additional columns in between, it skews the macro results. Can a macro be created to list the names of the column headers so wherever they are moved - the macro will still identify it and hide or unhide it? this may be an Excel 101 question - but not for me.
Thanks..