Copy VBA function down worksheet

**cbrandonsmith** · 03-16-2014, 10:28 PM

Hello,
I am trying to copy a function down a worksheet and can get all other formatting to copy but cannot get the double-click to hide rows to continue down. This is what I have so far:
#

Please Login or Register  to view this content.

#

Thanks in advance for your help!

**alansidman** · 03-16-2014, 11:02 PM

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html

(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

**cbrandonsmith** · 03-17-2014, 03:44 PM

B3 is the first cell this is active in and I need this to function in B13, B23 etc. Or another way about this would be to hide the next 9 rows for any cell in column B that is double-clicked. I am just now sure how to write this.
Thanks!