Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi Richard, sorry I can't send the original, but I made a sample spreadsheet for you. Note the original spreadsheet has many more columns of data.
There might be a better way to do this, but the first row in the DATA sheet is the row that will need to be checked for the word AIR or VENDOR, if there is a match then hide that column. The Main sheet Is were the macro start buttons are. I also need this to work from Excel 2010.
The file id is 447058.
Oh I forgot to mention that row one will be hidden from view in the normal state prior to any macros being run, thanks
Richard, I think we must have miscommunicated, I need the columns to be hidden versus the rows, thanks.
Richard, there is still something wrong, the unhide macro seems to be working, but the hide air and hide vendor is only partially working; only some of the columns that have these key words (AIR an Vendor) are being hidden, thanks.
Richard, here is a summary of how it should work.
If I select the HIDE AIR macro it should hide all columns that have the word AIR in row 1. (Column C,G and I)
IF I select the HIDE VENDOR macro I should hide all columns that have the word VENDOR in row 1 (columns A,B,D,E,F,H, and J).
Anything you can do to shorten the code would help since the real spreadsheet has about 100 columns.
Hope that helps.
Richard only row 1 needs to be checked for the key words (AIR or Vendor depending on the macro), maybe this will shorten the code?
It works! Yeah! Last question before I give you an excellent rating, how many macro are being used? I see four in total ( macro2, HideAIR, HideVendor, UnhideAll), but I see code in all of them for that appears to be related to each. Thanks