Hey guys,
I'm fairlly new to VBA programming. I want an updating field to be copied into the next empty column every 4 minutes and was wondering if anyone had an idea to do so, with the least amount of processing power to do so. At the same time, I want a time stamp to be inserted above the column.
At first I used "end.Xl" and copy/paste-special, but that was quite consuming of data power.
Preferably it should go to one worksheet to another, without automatic screen updates and such. This is the code I've come up with so far:
I also tried to get it run at 8:30 every morning, every 4 minutes, until 17:00 but seem to get it to work. Much appreciated if anyone could help me with this code as well.
Kind regards,
pippinsmckey
Bookmarks