Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
window with update value
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
window with update value
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???? pol wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
window with update value
Yes you are correct. That range name was given after this statement. I
corrected and working fine Again with thanks and regards Pol "pol" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
View cell contents as a pop-up window (similar to comments window) | Excel Worksheet Functions | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
Window XP update has caused excel to not operate | Excel Discussion (Misc queries) |