Greetings,
I've just been working on a macro that clears our template after we use it.
I imagined something like this would get the job done
But it says that it cannot change merged cells, is there a way around it?![]()
Range("E8,F9,K9,D10").ClearContents
Ok, silly me. This fixes it.![]()
Range("E8:J8,F9:H9,K9:L9,D10:J10").ClearContents
Bookmarks