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!


hi Livin,

if you don't matter with #REF! error





Le 2012-05-04 19:36, Livin a écrit :

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question