Hi everyone.
I'm using the following code:
Instead of:
Because I want only to copy the values, not the formatting. But I'm getting the following error:
"AutoFill method of Range class failed"
Any ideas what could be wrong?
Thank you
I'm using the following code:
Code:
Range("A2").AutoFill Destination:=rango, Type:=xlFillValues
Code:
Range(rango).FillDown
Because I want only to copy the values, not the formatting. But I'm getting the following error:
"AutoFill method of Range class failed"
Any ideas what could be wrong?
Thank you