| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy empty cells from one workbook to another - Code
Hello,
In addition to what I've written before, here is the code I wrote: Sub Dataacquire() Workbooks.Open "data.xls" Worksheets("sheet1").Range("b1:d19").Copy _ ThisWorkbook.Worksheets("sheet1").Range("b1:d19") ActiveWorkbook.Close SaveChanges:=False End Sub My problem that empty cells are not copied as empty and because of this I get an error messages in other worksheets (like #VALUE). How Can I solve this problem ? Thank you David Cohen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Data From Filled to Empty Cells | Excel Discussion (Misc queries) | |||
| Copy empty cells from one workbook to another - Code | Excel Discussion (Misc queries) | |||
| Copy empty cells from one worksheet to another | Excel Programming | |||
| Macro to copy value in empty cells | Excel Discussion (Misc queries) | |||
| SOS VBA Code Emergency: need to copy tell to empty cell direct below where values in adjacent cells in different column are equal to each other. | Excel Programming | |||
Linear Mode
