Recorded Macro doing more than what was recorded

[bartoax]

I have a macro that I recorded to copy columns E-H, and paste values, then delete columns L-R.

The problem that I am having is when I run the macro, instead of pasting values on just E-H, it pastes the values for A-K. I have formulas in some of the other columns that I need to stay as formulas.

Any suggestions on how to fix?

 

[Joe4]

You are welcome.

Basically, the last variation did the following:
- limited to just rows with data
- suppressed recalc until after all updates were made
- suppressed screen updating until all updates were made