using a macro to set " Replace" varaibles

T

Tony

I want to ask an input variable in a macro which has options say A,B & C then
want to replace this variable in a find and replace statement.
Eg Find Forecast A and replace all with Forecast "xxx" where xxx is the
input variable from the macro question.

How can I do this?
 
Top