AutoFill question

I'm trying to use variables to define an autofill range. As an example:

Please Login or Register  to view this content.

Yet I keep getting Run-time error 1004
AutoFill method of range class failed

TIA

Hi
I used xl 2000 and it worked for me. I put Jan in a1 and it filled till may.
Ravi

Hmm... Ok, let's try this:

Please Login or Register  to view this content.

I thought the rest of this was ok which is why I didn't include it originally, I guess I was wrong.

Thanks again.

Hi
In last but one row of the code, you select column M. In last line you define the range for col A (ie 1). try 13 (M)
Ravi

Originally Posted by ravishankar

Hi
In last but one row of the code, you select column M. In last line you define the range for col A (ie 1). try 13 (M)
Ravi

Thanks I can't believe it was something that dumb that I missed.