window with update value

P

pol

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
 
D

Dave Peterson

Make sure you have defined a name REBATE.

I'd guess that the workbook that's getting this formula doesn't have that
name--maybe a mispelling of the name or maybe the wrong workbook is active????
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
Click to expand...
 
P

pol

Yes you are correct. That range name was given after this statement. I
corrected and working fine

Again with thanks and regards
Pol
 
Top