We have to place a variable value at the end of the report heading and the value should get refreshed whenever we change the variable by using "Change Variable Value". I have created a macro and the value will get triggered unless and until we click on any where on a sheet. But, we want to automate this one by using a macro.
Ex: Quarterly PA Host Country Details As Of (Variable Date). Please refer the attachment for further information.
Please suggest me on how to place variable value at the end of report heading by using a macro.
Thanks in advance,