Need help with VB to link button to HYPERLINK formula

Hello all and thank you in advance,

I am using Office 2013.

Please see the attachment. I got a simple piece of VBA code from someone who was nice enough to give it to me. When it works it is supposed to allow the user to click on a button and then, using a macro, it clicks on a cell contents in column "H".

Explanation: I have eight HYPERLINK formulas in column "H" that populate an email based on contents in column "E". I have buttons in column "F" and I've right clicked on the tab name, and clicked "View Code" and then right clicked on "Sheet 1" named CVG. This links the VBA code I pasted into that module to the button. Next, I've right clicked on each button and selected "Assign macro".

The VBA code should work but I'm getting an error '9' - subscript out of range. How do I fix it? And please help me to understand the fix as I need to apply it to the actual sheet I am attempting to roll out

Thank you again

Thank you! That works!