VBA Write record to table

[kemit]

Good Day

is there a way of speeding up writing data to a table. The attached code writes data stored in variables to a new row in the table, this takes approximately 4 seconds, is there a way for it to be faster? screen updating is set to false and calculation is on manual.

What I have noticed is, in the workbook is indicated as "not responding" but the macro still runs

Your help will be appreciated.

Please Login or Register  to view this content.

[Norie]

Don't know if it'll speed things up much but you don't need to select anything or use Selection.

Also, even though you might have turned off screen updating and set calculation to manual elsewhere it doesn't guarantee that will still
be the case when running this code.

Please Login or Register  to view this content.

[kemit]

Hi there

Thanks I will try it.