Encounter Runtime Error 1004 "That name is already taken. Try a different one.

**ahsan.masood1980** · 02-11-2020, 01:03 PM

Hi,
i am new to VBA. Actually i was working on main sheet1 where i want to find the text value from cell A12 to another sheet2 in Cell B1. When i used the dynamic hyperlink formula which was success but it given me runtime error 1004 "That name is already taken. Try Different one.
Formula i used:

Please Login or Register  to view this content.

.

The reason is that i have used the VBA code to get the sheet1 renamed when particular cell text is changed.
i Used this VBA code in sheet1.

Please Login or Register  to view this content.

could you please help me to sort this out.
Thanks.

**Pepe Le Mokko** · 02-12-2020, 03:27 AM

Hi
please use code tags (#) to wrap code instead of HTML tags
Thanks

**ahsan.masood1980** · 02-12-2020, 05:19 AM

In the VBA code i am encountering a problem here in this part of above mentioned code.

Please Login or Register  to view this content.

.

Could you help me to get this error resolved.

Encounter Runtime Error 1004 "That name is already taken. Try a different one.

LinkBack

Thread Tools

Rate This Thread

Display

Encounter Runtime Error 1004 "That name is already taken. Try a different one.

Re: Encounter Runtime Error 1004 "That name is already taken. Try a different one.

Re: Encounter Runtime Error 1004 "That name is already taken. Try a different one.

Thread Information

Users Browsing this Thread

Similar Threads

Macro Not Working in "Protected View". Runtime Error 1004

[SOLVED] Frequently Used Macro now Giving a" Runtime Error '1004 Application-Object Defined Error"

Issue with "Runtime error 1004: Cannot rename a sheet to the same name..."

[SOLVED] Excel VBA Runtime error '1004' "If WorksheetFunction.Find" function

Vlook up VBA Error when value not found "runtime error -1004"

runtime error "1004", no data selected to parse

Bookmarks

Bookmarks

Posting Permissions