hmm, if I remove the contains of the For Each loop, i just end up with a copy of the original with formulas and all.
The funny thing is that for a brief moment when running the macro, it also shows "#VALUE!" in the cells.
But once finished, values and formulas return...
this led me to think; am I copying values at the time when it is showing ""VALUE!"???
Originally Posted by Webmonkey
Hi!
This seem to do the loop with end save OK, but all cell which before had numbers, now screem "#VALUE!" at me.
What went wrong???
Reply With Quote