Hi all,

I have the following code that I'm trying to implement. The code sums a column of data in a tab and pastes the value and time into another sheet every x minutes.

The code seems to work fine when I have the tab open and I'm sitting on it, however when I move to another tab I get an object defined error.

I've tried to counter this by including the worksheet name and sheet name in the code, but with no luck.

Eventually if I can get this to work I'd like it to have this work across 3 separate sheets, summing a column in each on a regular basis without the user being interrupted or being bothered by the code working away.

Please Login or Register  to view this content.
In addition to the above I have the workbook_open and workbook_beforeclose code within the thisworkbook tab.

Any ideas on where I might be going wrong?