| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying values from one Workbook to Another
Hi Tom,
Lol. Thank you for pointing out my error Tom! I had thought I erred with assigning the sheet object. But the error was a simple "s". Again, thank you! Best regards, Kevin Tom Ogilvy wrote in message ... The value property doesn't have an "s" on the end oCurrentSheet.Range("DestRange").Values = oSourceSheet.Range("MySourceRange").Values should be oCurrentSheet.Range("DestRange").Value = oSourceSheet.Range("MySourceRange").Value |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying workbook formating to a differnent workbook | Excel Worksheet Functions | |||
| Copying Formulas from Workbook to Workbook | Excel Discussion (Misc queries) | |||
| formula for copying values from one workbook to another | Excel Worksheet Functions | |||
| Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
| copying values form one workbook to other | Excel Programming | |||
![Kevin H. Stecyk[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
