Copy and Paste Filter Part 2

[jkelly228]

Hello All,

I have the below code that I use to check 60,000 lines of code (this is part of a much bigger program that I have asked many questions on before). As you can see, with the case I find a value and put in an equation 2 columns over for 12 columns when that value is found.

This is a very slow process. Is there way to make this faster. I was given info on a filter option for a similar problem (see this thread), but I haven't been able to make the same thing work when putting in a formula for a mass amount of data.

I would appreciate any feedback if someone knows how to make this a faster piece of code.

Please Login or Register  to view this content.

Respectfully,

Kelly

[rylo]

Hi

I'd start off by blanking all the cells that need to be blanked (column 42???).

Then I'd perform 4 filters and put in the relevant formulas for the items returned. It may pay to turn off the autorecalc while this is happening, then turn it on again at the end of the run.

If you can't get things going, then build a small example file - maybe 50 rows or so with representative data and structure so we can work with something concrete.

rylo

[jkelly228]

Hi Rylo,

Thanks for the input. Below is the code that I got for copying and pasting a single value into a Filter set of rows. I just need it to post in an equation instead.

Please Login or Register  to view this content.

[rylo]

Hi

Something like

Please Login or Register  to view this content.

rylo