I copied the Rsearch code into VBA and the formula is available now in Excel. However when I select the cells I want to use in the Thomson Reuters search bar, it says "inactive cells selected". I am not sure what is the problem, does anyone have any idea?
I'm afraid I don't quite understand the issue here, but it doesn't sound like it's related to the use of any Refinitiv APIs. Since this forum is dedicated to software developers using Refinitiv APIs, I may suggest you reach out to Refinitiv Helpdesk, who can help you with using RSearch function in Excel.
Alternatively, please describe the issue in detail and include step by step replication procedure that we could follow on our end. Screenshots illustrating the issue would also be most helpful.