Hi There,
I a new to VBA coding. I have encountered runtime error 1004 "That name is already taken. Try a different one.", when i have used the dynamic hyperlink formula from one sheet to another.
Suppose i got the text on sheet1 Cell: B10 i want to match the text in sheet2 Cell: B6, where in sheet2 there are lookup formulas used to a different sheets. Now when text in sheet1 matched with text in sheet2 i clicked on link it gives me runtime error 1004. Could you please help me resolve this problem ?
Formula i used:HTML Code:
Bookmarks