Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro/Forumula to SUM values from Sheet that does not always exist
I have a macro that creates Sheet9 as needed. On Sheet1 I need to SUM values
from Sheet9 when it exists. Currently I use a basic formula but when the sheet gets automatically deleted and recreated, using a macro, the formula errors and does not "fix" itself when Sheet9 gets recreated. I prefer to use a macro where I can specify a Sheet/Cell to place the SUM, when Sheet9 exists... but if you have a formula that will stop if from erroring that would work too. thx for the help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro/Forumula to SUM values from Sheet that does not alwaysexist
hi Livin,
if you don't matter with #REF! error =SUM(INDIRECT("Sheet9!A:A")) else =IF(ISERROR(SUM(INDIRECT("Sheet9!A:A"))),"",SUM(IN DIRECT("Sheet9!A:A"))) -- isabelle Le 2012-05-04 19:36, Livin a écrit : I have a macro that creates Sheet9 as needed. On Sheet1 I need to SUM values from Sheet9 when it exists. Currently I use a basic formula but when the sheet gets automatically deleted and recreated, using a macro, the formula errors and does not "fix" itself when Sheet9 gets recreated. I prefer to use a macro where I can specify a Sheet/Cell to place the SUM, when Sheet9 exists... but if you have a formula that will stop if from erroring that would work too. thx for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to check the Sheet name exist before running Macro code | Excel Programming | |||
Return a value if two other values exist | Excel Discussion (Misc queries) | |||
Want a trace a same values exist in two different sheet | Excel Worksheet Functions | |||
Retreive part of the value from each cell - Macro and/or forumula | Excel Programming | |||
STOP MACRO IF CELL "A1" IS EMPTY OR SHEET DOESN´T EXIST | Excel Programming |