none
help with macro RRS feed

  • Question

  • may I please get your help 

    I have no clue how to work vba macro at all 

     if the value is 0 I would like to hide the column done in real time if possible 

    I need sheet13 range ("s8:bs8") when value is 0 to hide the column 

    eg: ='COMISSION (2)'!F92 this calculates from 5 different pages to work out a total 

     if the value is 0 I would like to hide the column done in real time if possible 

    the cell range changes automatic depending on value in cel ='COMISSION (2)'!F92 but when the value is 0 I would like to hide the column. 

    I would copy the macro to work on many different sheet of the same excel book 

    I hope that is all the info you need 


    Sunday, January 19, 2020 7:59 AM