On Sunday, June 9, 2013 6:06:03 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Sun, 9 Jun 2013 04:35:14 -0700 (PDT) schrieb Howard:





On the actual (non test) worksheet with same code and same cell address, for some reason it insists on including the Caption of a Forms button that has

"C. Fmt." (a button that calls a conditional formatting macro.)



If I eliminate the button, all is good. I have moved the button around on the sheet to see if that made any difference, but the code finds it, if it exists. I tried a new button and entered the word "Doneky" and the code offered up "Donkey" as a suggestion. Accept Donkey and then it goes to AK15 where I have "Sceince" and does its job there. If Donkey is spelled correctly on the button then the code goes straight the AK15 cell and does its job there.



I tested it with ActiveX-Button and Forms Button, but the macro didn't

check the button. Even if the button calls the macro it don't check it.

I have no idea.





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

I thank you for giving it a look. Weird, but easy enough to work around.

Regards,
Howard