Run time error 9 subscript out of range

I am having an issue with run time error '9': subscript out of range, can someone please help me with this? I looked at the following thread but couldnt figure it out http://www.excelforum.com/excel-prog...run+time+error

Please Login or Register  to view this content.

Thank you for your guidance by the way, new to the forum and haven't read through all the proper etiquette. Yes there is a hyperlink in all cells b1:b:10. I also put the code in to pop up error and go to the next but each one errored after it. It just seems to stop at b4. The link works when I click on it, wont for you because its through internal reporting on our network.
Below is the formula I have in place for this hyperlink. http://ert.pbg.pvt/infosis/reportvie...aJHqQjjT7IplKo
=HYPERLINK(LEFT(MID(A4,FIND("http:",A4),1000),LEN(MID(A4,FIND("http:",A4),1000))-2),LEFT(MID(A4,FIND("http:",A4),1000),LEN(MID(A4,FIND("http:",A4),1000))-2))

You mean like this? If so, I get a compile error: syntax error

Please Login or Register  to view this content.

It comes up red and with the same error as earlier stated.

Still the same error, just now the message box comes up that I have to click ok on. Thank you for help.
ERT Utilization.xlsm

THANK YOU! I was pretty sure I had the same formula in each cell but I dragged them down and now they all run. Thank you very very much! Consider this solved.