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?
TIA![]()
Please Login or Register to view this content.
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?
TIA![]()
Please Login or Register to view this content.
Yes, separate line.
Entia non sunt multiplicanda sine necessitate
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,
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks