| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How copy cell workbook to workbook?
Can someone tell me why this isn't copying cell 2,3 in 2nd workbook to
cell 5,2 in 1st workbook? It prints the msgbox properly and runs w/o runtime errors. Sub Copy_Cell_from_2ndbook_to_1st_book() Workbooks(1).Worksheets(1).Cells(5, 2).Value = Workbooks(2).Worksheets(1).Cells(2, 3).Value MsgBox "Done" End Sub Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How can I copy a cell from one page to all pages of a workbook? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
