Posts by LukeBeedle

    I am trying to hide various rows of a worksheet called "Storage & Distribution" if the value of cell C46 of a worksheet called "General info & study design" is changed. I have set a lookup on the "Storage & Distribution" sheet for reference (C7). The code I am using is shown below but it does not work until I type something into one of the cells of the "Storage & Distribution" sheet (only the red text). Is this something to do with using a Worksheet_Change Vs a Worksheet_Calculate? the rest of the code works fine as this is based on a drop down menu on the"Storage & Distribution" sheet and does not reference any other worksheets or use a formula. Any help would be appreciated.