Greetings One and All,

Hope this finds you well.

I have written a macro that does the job but is slow to run... can you take a look provide any feedback for improvement?

The purpose of the macro is to write data into a data workbook (datawb_) - ~100 sets of data - each set containing ~50 rows x 50 columns worth of data to write in.

The macro matches the target data (with exclusions) and then populates into the datawb_.

It looks sound to me - may simply be a case of the volume of data being written - potentially the match function slowing the macro or the sequence of code not written efficiently.

Any input would be great :-)

Please Login or Register  to view this content.

Many thanks,

puppet_master2501