It sound like the Focus of which workbook ror worksheet is active when the
code starts to run. You probably have to add into your code
workbooks("book1.xls").activate, worksheets("sheet1").activate, or
windows("book1.xls").activate.

"academiac" wrote:

I have written a series of spreadsheets with cell logic for tax purposes, for
here in australia we have a system of GST tax which is insane. Anyway, I have
cell logic which works, then all of a sudden, I open the template file (saved
as a read-only file) and when I fill it out, I discover some of the logic is
not executing properly. I freak out, change the logic, and it suddenly works
again in a different fashion. I go to fill in the rest of the cells in the
template and another spread sheet right next to the one I am working on has
the original logic in it, and it works fine. It is driving me nuts trying to
figure out how to make it execute consistently. It is a laptop (DELL Inspiron
9400) with Vista and Excel 2007, all pretty brand new. My last updates are 19
September. I have the K numbers for them but I don't know if that will help.
It is driving me flaming nutty trying to figure out why. Any ideas?