Is there any way that 'filling' can be restricted to values only and not formatting, perhaps through VBA?

[Rnkhch]

Hello,

I know that it is possible to right-click and drag and then select 'fill without formatting', but is there any formatting changes can be disabled for dragging/filling, perhaps through a VBA code?

Thanks for any input!

 

[Rnkhch]

I thought to post the new thread here so people can easily follow along:

How to temporarily unprotect a sheet to allow VBA code to run and reprotect immediately, using VBA?

Hello, First a little background about this question. Actually this is related to and in continuation of another thread of mine (Is there any way that 'filling' can be restricted to values only and not formatting, perhaps through VBA?). So in this thread, johnnyL wrote magical code...

www.mrexcel.com

 

[johnnyL]

Thank you!