excelnooby
New Member
- Joined
- Jun 30, 2009
- Messages
- 10
Hi all,
Let me simplify my example instead of giving you all the full background on why i need to perform this function.
Basically, I have a range of cells "a1:a20", with numbers entered in each cell in the range, say 1, 2 or 3. I want to be able to write a macro to assign to three different buttons that will allow me to hide entire rows depending on the number entered in that range. for instance, click a button to hide all rows with the number '1' entered in column a, click a button to hide all rows with the number "2" entered in column a, etc.
thanking you in advance
Nooby
Let me simplify my example instead of giving you all the full background on why i need to perform this function.
Basically, I have a range of cells "a1:a20", with numbers entered in each cell in the range, say 1, 2 or 3. I want to be able to write a macro to assign to three different buttons that will allow me to hide entire rows depending on the number entered in that range. for instance, click a button to hide all rows with the number '1' entered in column a, click a button to hide all rows with the number "2" entered in column a, etc.
thanking you in advance
Nooby