Autofill selection down to last row

**pluginguin** · 11-01-2011, 10:04 AM

Hi,

I have a macro, that will add records to my table using vertical lookup formulas in several columns from data in another worksheet.
Before I run the macro, I add the record-id's for the new records in column A.
Then I run the macro.
Everything runs smoothly, until the Autofill copies the formulas from the first new record down to the last new record.

What do I need to change in the code, to make the autofill do it's job correctly?
Attached are two Screenshots. One with my code (snap2.jpg) and one with a view of part of my table (snap1.jpg)
Snap1.jpg
Snap2.jpg.

Please Login or Register  to view this content.

**Domski** · 11-01-2011, 10:10 AM

You don't need to use Select when writing VBA code. If you post the code rather than an image I can revise it for you (remember to use code tags).

Dom

**pluginguin** · 11-02-2011, 11:24 AM

Hi Dom,

I added the code.

Thanks,

Tijs

**Domski** · 11-02-2011, 12:03 PM

Here you go:

Please Login or Register  to view this content.

Dom

**pluginguin** · 11-02-2011, 12:26 PM

Thanks,

working like a charm.

Only one issue... when I save the file it displays a message that it can not save external links. Probably because they are in the VBA-code.
Can something be done about this aswell?

Regards,

pluginguin

**Domski** · 11-02-2011, 12:32 PM

Hi,

It won't matter that the external file name is mentioned in the code. There must be a formula or something referring to an external file still in the workbook.

Dom