How to add text to find in codes?

[WS_Chai]

Hello there,

I have some codes here which I input in invoke VBA, but I would like to add “ref!” or “name?” on top of the current “#DIV/0!” in the codes so that the bot can read and find either one of them.

May I ask for your guidance on where and what codes shall I add in between the codes for the bot to find either one of them?

Thank you!

[WS_Chai]

I tried to define the variable first on all the texts i intend to find, but the bot is not reading all 3 texts. Hope you can advice and correct me.