Speeding up a Macro (Shorten Code)

[t0m46]

Hey all,

I have written a Macro but it takes along time to do what I want it to. I am new to VB so to I have probable coded it in a long way.

if any one could look at the code and let me know any bits I can cut out or change that would be great.

Please Login or Register  to view this content.

[pike]

t0m46
one change

Please Login or Register  to view this content.

[royUK]

You don't need to make the data sheet visible or select it.

The progress bar will probably slow it down somewhat.

I can't test this

Please Login or Register  to view this content.

[romperstomper]

See if this is any faster:

Please Login or Register  to view this content.

[t0m46]

Hey,

Took some from each one of you. does work faster but it think it is just going to be a slow macro.

thanks for your help

Tom