Help speeding up VBA

[Zimmerman]

I know there's an easier way to do this so I'm looking for some help on how to write this code to make it easier and faster.

Please Login or Register  to view this content.

[alansidman]

Try this:

Please Login or Register  to view this content.

[Zimmerman]

that would work but the only problem is I don't want to put formulas in the sheet at all. Trying to prevent the user from messing formulas up without locking the sheet.

[alansidman]

In that case, add a copy and pastespecial.values to the code to copy the calculated fields and paste over them. This will ensure that only values are reported.

ie.

Please Login or Register  to view this content.