Paste special syntax Book to Book
Copy RngFrm in workbook A to RngTo in workbook B.
RngFrm and RngTo are from InputBoxes.
RngFrm.Copy RngTo
All this works just fine.
Want to add the PasteSpecial.Values because RngFrm is formulas and I want RngTo as values only.
I've tried With RngTo / End With but cannot get the proper syntax PasteSpecial in without errors.
Thanks.
Howard
|