Ok, so apparently I am an idiot.
The worksheet is protected, therefore I had to unprotect it, then copy it over, then protect it again.
I had that in my previous code, but when I applied the OnTime method from the sample files I forgot to add that one line. Blargh.
I need some fresh air...
[Edit]And damn you for being so fast and helpful, Richard! I was just going to delete my last post to hide my stupidity, but you already saw it. lol.[/edit]
Bookmarks