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.
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?
Bookmarks