if blank do nothing vba

[hopefulhart]

so i have a worksheet that has four columns with text that i enter manually. i created a vba code that will create a hyperlink to other workbooks in column B everytime certain text is entered, and that worked fine. the problem is i change the text often and insert and delete rows constantly, and when i insert a new row into the field i get the message "run-time error '13': type mismatch" and have to either end or debug every time.

here is my code

Please Login or Register  to view this content.

i was wondering if there is a way to clean this code up and resolve the issue with an 'If blank - do nothing' or someting else

thanks

[6StringJazzer]

I understand your code but not your problem/question.

the problem is i change the text often and insert and delete rows constantly, and when i insert a new row into the field i get the message "run-time error '13': type mismatch"

Do you mean you insert and delete rows in your worksheet, or you insert and delete lines of code? What does "insert a new row into the field" mean? What's "the field"?

What line of code is indicated when you get that runtime error?

If Target is blank, then your code will do nothing just the way it is. So I am not sure what you are getting at.

Regardless, I would write the code like this (compiled and tested). I am taking advantage of the fact that the file name you are linking to is the same as the string in the target cell. If that assumption is not always true then this won't always work.

Please Login or Register  to view this content.

[hopefulhart]

thanks for the reply

your new code works just as well except there are two folders that the hyperlinks go to, half are in CMHL Teams and the other half are in CHL Teams. yes i mean when i insert and delete rows on the worksheet i get the error message. on my original code it indicates this line

Please Login or Register  to view this content.

when i put your code in and selected row 2 on the worksheet and inserted a new row i got the same error message and it indicated these lines

Please Login or Register  to view this content.

[6StringJazzer]

Can you attach your file?

[hopefulhart]

yep here it is

[hopefulhart]

so i found another post that seemed to fix the issue

i added this line of code

Please Login or Register  to view this content.

thanks for all your help

[6StringJazzer]

I didn't notice the two different leagues, I think this takes care of that.

Please Login or Register  to view this content.

[hopefulhart]

thanks got it running nicely