Disable fill series

Hi,

Does this help?

http://excel.tips.net/Pages/T002594_..._Workbook.html

Hi,

What that code does is disabling the autofill feature. I want the autofill feature to be enabled but by default copy the cell value, and not creating series. Actually I want the autofill feature to only support copy.

You made me think though :-)
There is a property called XlAutoFillType. Is there a way to set this to xlFillCopy by default? (or maybe disable all the others? - see link)

Regards
Jan-Roger