Desired name not appearing in current cell when presing control + J

[keshavtale]

In the attached file there is VBA code when i am in current cell and press control + O then AKOLA MANDI appear in current cell, whein i press control + t the AMRAVATI MANDI appear in current cell but when i press control +j then JAY AMBE TRAERS CO. NOT appearing in current cell so please modify the VBA code as requirment

[BadlySpelledBuoy]

In your SetonKey sub, change this line:

Please Login or Register  to view this content.

For this

Please Login or Register  to view this content.

Then run the WorksheetActivate sub and all should work as expected.

BSB

[keshavtale]

I could not understand how to do , can you send me attachment,
and also how to run worksheetactivate sub

[BadlySpelledBuoy]

Save the attached to your computer then open it and give it a try.

BSB

[keshavtale]

I download your file and it is perfectly working but when i copy your code to my original file it showing error see attachment for error

[BadlySpelledBuoy]

Close your file then open it again.

BSB

[keshavtale]

Thanks for your help, now everything is fine

[BadlySpelledBuoy]

Glad I could help

BSB