I have VBA code in my workbook that looks like this:
Sheets("DATA").Select
Range("E2:K2").Copy Sheets("Website paste").Range("B1")
Range("E3:K3").Copy Sheets("Website paste").Range("B9")
Range("E4:K4").Copy Sheets("Website paste").Range("B17")
Range("E5:K5").Copy Sheets("Website paste").Range("B25")
Range("E6:K6").Copy Sheets("Website paste").Range("B33")
Range("E7:K7").Copy Sheets("Website paste").Range("B41")
Range("E8:K8").Copy Sheets("Website paste").Range("B49")
Range("E9:K9").Copy Sheets("Website paste").Range("B57")
Range("E10:K10").Copy Sheets("Website paste").Range("B65")
The problem with this code is that each range is copying FORMULAS rather than VALUES into the destination cells. What do I need to add to the code to circumvent this behavior...and have the code paste ONLY VALUES into the destination cells?
Bookmarks