How to unhide certain columns, if a DV cell contains 1 or more options from the pick list RRS feed

  • Question

  • Hi all,

    Can you tell me how to unhide certain columns or multiple columns, depending on the pick list options from a DV cell? I already have the DV cell/column coded to enable 1 or multiple options to be selected and displayed in the cell.

    Many thanks


    Tuesday, August 29, 2017 3:31 PM

All replies

  • Your post appears to indicate that you are using VBA code to make multiple selections from a DV DropDown. Is this correct? If so, post an example of the output you have from the DV. The format of this output is required to determine how to code the rows or columns to unhide.

    Also need to know how to determine if the output refers to rows or columns.

    Regards, OssieMac

    Wednesday, August 30, 2017 11:11 AM