Excel Hide Columns by Macro

**friendlykashish** · 05-08-2010, 12:39 PM

I want to hide columns by typing words, (e.x) Column A, good,very good ,poor & avarage
If select good from the list, the Column D, F, H should be hide,same way if select poor C,E.G
should be hide,but D,F,H unhide, likewise.This should be done through Macro. Can any one Help me?

Regards,

**royUK** · 05-08-2010, 12:44 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**friendlykashish** · 05-11-2010, 03:03 PM

Dear All,
column C4 would have one of several codes (GOOD, VERY GOOD, AVERAGE, POOR, etc.), When the user selects either “GOOD”, “VERY GOOD”, “AVERAGE” or “POOR”, I want to hide columns.(E.X) If select GOOD, then E, F should be hide, if it is very good, I,J,K,L should hide. My original sheet is password protected. I have attached dummy sheet.

Thanks,

.

**friendlykashish** · 05-20-2010, 01:09 PM

Hi,

The excel sheet contains three rows, C4,C5,C6 & D Column is Average Column.

Now my question is "By Macro" i want to calculate Average & If it is data two rows

that also caluculate Average.( Data may be 3 OR 2 Rows, but Average should be done.)

Best Regards,