Finding multiple cell addresses

[danielpalfrey]

Ok guys, I am going to try and explain this clearly this time.
I have a spread sheet, in column A there is a list of words. There is a button on the spread sheet, we will call the button tst.
The layout for column A is a word, then some cells containing info then another word. The words that are important are one two three four five six seven eight nine ten end

Upon clicking the tst button I need the cells containting the info to be hidden, but the numbers as above need to stay showing.

As an example when I click tst button A1 contains "one" then A2:A5 is just information so 2:5 hides A6 contains "two" so the stays showing but then the cells below that with just info hide until the cell containing "three"

I have been able to get this on a double click even for each number but have been asked to make a button to do it all at once.

Many thanks

 

[James006]

You are welcome ...

 

[danielpalfrey]

I have even been able to modify the code to clear my irrelevant rows, this was well written and easy to understand what was happening

 

[James006]

I have even been able to modify the code to clear my irrelevant rows, this was well written and easy to understand what was happening

Thanks for your kind words ...