Prevent increment when using autofill

[happydonut]

Hi,

I have an Excel sheet, where sometimes I just want to left click and drag a value from a certain cell and downward to copy/paste it (the autofill + sign) But in some occations, the value is being added by one (1) for each row. Can I prevent this from happening with a VBA code? I only want to copy the original value.

Thanks.

 

[Joe4]

I thought you were looking to have a specific range autofilled, not that you were trying to change default behavior of Autofill as you are interacting with it.
I do not believe there is any way to do that either.

 

[happydonut]

Al right guys,
Thanks anyway

 

[Fluff]

Glad we could help & thanks for the feedback.