Is there an Optional Parameters to Clear on .Insert

Hi,

VBA allows us to CopyOrigin:=xlFormat.... on an .insert, but I want to ClearFormat. How can I do that? Or do I have to do it on a separate line specifying the object again?

Please Login or Register  to view this content.

TIA

Hi,
That was my suspicion, but just wanted to confirm. BIGThx for responding. I feared this would go unanswered. I had checked the MSDN library & object library before I came & asked you guys, but just cause I check means very little to me. I have been known to completely miss the obvious.
All the best,