Hi, I am writing a Macro in (Excel 2003) and I am having trouble with
the Autofill command. First of all I am just copying my movements, not
writing them in VB.

The problem that I am having is that I need the Macro to use the
Autofill command that I am giving it. The reason is I am writing a
Macro for work that will be plugging in data that could be 100 rows, or
2000 rows. I am using the VLOOKUP to pull data on to the sheet and than
Autofill to populate all the rows with the VLOOKUP data.

It works when I run the Macro, but if there were 121 rows of data when I
wrote the Macro, it will only go to 121 rows when I run the Macro.
Which is the problem.

Is there any way to get around this issue with out having to write the
Macro in VB?

Thanks,
Andrew


*** Sent via Developersdex http://www.developersdex.com ***