Insert Range Involve ClipBoard?

[Peter]

Hi all,

I try to Insert a range in order to prepare some space for myself in VBA,
but I found that the data in clipboard willb e pasted right under my inserted
range/area if the clipboard is not empty. Is the insert range method make use
of Clipboard? If so, how can I temporary disable it? I don't want to clear
the clipboard (can I do so and how?).

Thanks,

 

[RB Smissaert]

It will be easier to answer this if you posted your relevant code.

RBS