| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy worksheets to new book without linking to original book | Excel Discussion (Misc queries) | |||
| Excel Work Book Copied Into Word With Paste Special, Excel Workboo | Excel Discussion (Misc queries) | |||
| 'BeforeClose' code problems:book won't close if more than one book is open | Excel Programming | |||
| I would like to copy & "paste special" an entire book | Excel Worksheet Functions | |||
| Open book, check for macros, close book | Excel Programming | |||
Threaded Mode
