AutoFill down non contigous Columns

[Rikkdh]

Me again...

I'm having performance issues running a series of macros that perform calculations on worksheets (20 of them).

Each calculation is the same and runs on each of the worksheets, the worksheets have the same columns but the column length varies hugely, some have 20 rows, some have 40K+. The columns are non contigous so right now I have fixed the length of the range to 50,000 to ensure that the formulas copy down and that there are no breaks when it fills down, but even this isn't working as i'm getting range errors and its taking what feels like years to run!

Can anyone suggest a smarter, more efficient way of doing this...

I've attached some code samples below:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[ragulduy]

Well you could try something like

Please Login or Register  to view this content.

Probably don't really need all the separate modules either:

Please Login or Register  to view this content.

[Rikkdh]

Cheers yudlugar...worked a treat, nice and simple too, just how we like it Nice and efficient...