I want to create a simple macro that will copy a range of cells with information generated by formulas on sheet 2, to a range of cells on sheet one. I need to paste only VALUES on page 1, leaving the formulas on page 2 in place.
I tried the following:
Sheets("data").Range("A3:A16").Copy Sheets("combat").ActiveSheet.Range("A3:A16").PasteSpecial xlPasteValues Sheets("data").Range("C3:C16").Copy Sheets("combat").ActiveSheet.Range("C3:C16").PasteSpecial xlPasteValues Sheets("data").Range("D3:D16").Copy Sheets("combat").ActiveSheet.Range("D3:D16").PasteSpecial xlPasteValues Sheets("data").Range("E3:E16").Copy Sheets("combat").ActiveSheet.Range("P3:P16").PasteSpecial xlPasteValues Sheets("data").Range("F3:F16").Copy Sheets("combat").ActiveSheet.Range("R3:R16").PasteSpecial xlPasteValues Sheets("data").Range("G3:G16").Copy Sheets("combat").ActiveSheet.Range("Q3:Q16").PasteSpecial xlPasteValues Sheets("data").Range("H3:H16").Copy Sheets("combat").ActiveSheet.Range("S3:S16").PasteSpecial xlPasteValues
it copies data from the cells but does not paste into the other sheet.
If anyone know where I am going wrong, please let me know!
Best Answer
If you're going the VBA route, you may as well avoid copy/paste because it is not very efficient.