Hi everyone. I am just learning VBA and I have an issue I cannot resolve. I have a row (A) with values of either 1, 2, or 3. These values are derived from a formula. I want the rows to hide based off of the value in cell K4, which is an input from the file's end user/operator. If the cells in row A match cell K4 the un-hide that row, if not then hide that row. If the user changes that value, I need row 'A' to un-hide and re-hide based off of the new value. I prefer to use some VBA code. The rows to be hidden and unhidden would be row 70 to row 6100.