Oct
2
awarded Popular Question
Jul
6
comment Create a macro that would hide and show columns based on selection from a dropdown
Thanks Trefex - I will give that a go. I'm assuming that Cells(A1, B1).EntireColumn.Hidden = True would hide columns A and B as they contain cells A1 an B1. Ideally I would get this to work based on a named cell to identify the comn to be hidden. Gonna give this a try right away. Thanks again!
Jul
6
revised Create a macro that would hide and show columns based on selection from a dropdown
excel uses vba not vb script
Jul
6
asked Create a macro that would hide and show columns based on selection from a dropdown