Can we disable the AutoFill functionality on certain cells only ?

[Jaafar Tribak]

Hi.

I want to prevent copying onto some specific cells when holding and dragging adjacent cells . In other words not to allow AutoFilling should those specific cells come within range of the autofill area.

Disabling the AutoFill functionality via ( Tools>Options>Edit>Allow Cell Drag and Drop ) is not an option because this applies to the entire application. I only need this on specific cells and want to keep the AutoFill feature for the rest of the worksheet.

I have been playing around with some code but it is proving more difficult than I initially thought unless I am missing something.

Any ideas ?

 

[RoryA]

Are you locking the clipboard at the start of the code?

 

[Jaafar Tribak]

Thanks everyone for your help.

I have built on Andrew's last suggestion and it is now working just fine.