AutoFill - help with thid

[garrbel]

Hi

I have this code:

Range(Cells(i - 1, 1), Cells(i - 1, 42)).AutoFill Destination:=Range(Cells(i - 1, 1), Cells(i, 42)), Type:=xlFillDefault

With this code I would like to copy but it makes a list. I mean I have in a cell 0,25 .
When I run a code it fills 1,25 --- 2,25 and I would like to have 0,25 0,25

What's wrong?

Thanks

 

[garrbel]

I guess I found. I have to use Type:=xlFillCopy