Hello all,
I am slowly getting into the world of VBA and Macros to which I have a question.
On the attached file there are a number of rows hidden. I would like it to function so that if I enter 3 into F2, the rows row 8 would be shown. If the value in F2 changes to 5 then rows 11 to 55 would be hidden etc.
I have seen some similar questions to this on this already on this site and others, but they usually focus on hiding rows where a particular value is found.
Many thanks in advance for your input.
I am slowly getting into the world of VBA and Macros to which I have a question.
On the attached file there are a number of rows hidden. I would like it to function so that if I enter 3 into F2, the rows row 8 would be shown. If the value in F2 changes to 5 then rows 11 to 55 would be hidden etc.
I have seen some similar questions to this on this already on this site and others, but they usually focus on hiding rows where a particular value is found.
Many thanks in advance for your input.