Hai all,

ActiveCell.FormulaR1C1 = "=RC[-7]*REBATE"

When I am running the above macors , the excel will popup a new window
for save as the exisitng excel with 'update value <file name. This will
create an unncessary disturbance to the users who are using the excel with
that macors. I kindly request an expert advice to solve the problem .

With thanks and regards
Pol