Copy a range, and then paste back the values only.

[Angry Robot]

Hi All,

I have a worksheet with several lookup formulas to populate data and several multiplication formulas to determine price totals. When I release this worksheet to coworkers I would like the formulas for determining price to still function, but I would like the lookup formulas to be replaced with just the required data. So I would like to write a macro that copies a range of cells (A2:E84) and then pastes that data back into the same range as values only. I can do it manually and it works, but I know there is a way to do it quicker with a macro, I'm just not skilled enough with VBA to figure it out.

[buran]

This will work with ActiveSheet

Please Login or Register  to view this content.

[Angry Robot]

Thank you!