Using Autofill with Destination Parameter as a Variable

Hi I'm having a bit of a problem with syntax here.

Please Login or Register  to view this content.

If I replace rng.AutoFill Destination:=Range(rng_AutoFill) with the commented out version rng.AutoFill Destination:=Range("A1:E36") it works fine. I can select the rng_AutoFill range, I don't seem to be able to use it with a variable name.

Any comment gratefully appreciated.

Perfect. It works fine now.

Thanks
Martin