Improving this set of code.

[Ra21V12eN]

With the help of many threads on this board and other sites on the net, I've been able to hash together a full piece of VBA scripting for an Excel file, which is honestly my first attempt at writing VBA.

Thanks to others who've already helped me on another thing I was attempting to accomplish, my macro now works exactly as I need it to.

This is one section of the code that I'm not comfortable with and I believe there must be a better way to write this to make it cleaner and better code. I'm posting this for my learning purposes so that I can get better at this.

Please Login or Register  to view this content.

This code is basically doing the same thing to two different worksheets in this file.

Thanks in advance

Chris

[shg]

I can't test this ...

Please Login or Register  to view this content.

[Ra21V12eN]

SHG,

That set of code definitely looks more efficient except for that there are different formulas to fill down on each sheet. The formulas look the same except for the final fill down references different fields. Is there still a way to do that in your example?

Chris

[shg]

Doing this a little blind, but I think this should work ...

Please Login or Register  to view this content.