Can’t remember the code to use

[ipbr21054]

I have a specific cell which is J9

I have a spreadsheet of user information.

Now I cant remember the name of the code to use but when a name is entered into cell J9 this code would then look at the spreadsheet in column D for the same name & select its cell.

Thanks.

 

[MARK858]

Reset the macro and if you click Tools - References and scroll down the list does anything have Missing along side it?

Asking this because of the compile error you got in your second to last post.

 

[ipbr21054]

Hi,
NO,most of them end in Library but nothing shown missing.

I think i will need to go back and use the original file as this is just all very strange.

 

[ipbr21054]

Mark858 & NoSparks,thanks for trying to advise/sort this but i have no choice to reverting to using my original file.
Not something i wanted to do but need to get to work tomorrow & we have spent some time on this.

Thanks for your efforts & sorry i wasnt able to use what you advised.