VBA to copy and Paste

LUIS FREUND used Ask the Experts™
Wanted to get a vba code that will for example:

Copy cells A4 to K500 and paste the values back to A4:K500 on the same tab called MAIN_PN

The thing is that I have formulas on cell A4:K500 and wanted to paste the values to get rid of the formulas.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You don't need to Copy/Paste to remove formula. Use this instead...

With Worksheets("MAIN_PN").Range("A4:K500")
    .Value = .Value
End With

Open in new window


Awesome......works perfect!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial