bamaisgreat
Well-known Member
- Joined
- Jan 23, 2012
- Messages
- 831
- Office Version
- 365
- Platform
- Windows
I am trying to copy a Range of cells called "Line4" to another workbook "Fmi Saw Archive.xls"
(The range consist of cells A4,A6,A12,A15,A16,A17)
After copying "Line4" I need it to copy a Range called "Line5" to the next empty row.
(This Range is bascially the same B4,B6,B12,B15,B16,B17)
and so on and so on
I have 21 Different ranges I need to do this with. They are almost the same as mentioned above, just going to the next line.
Im not sure if it is required but to me it is not necessary for "Fmi Saw Archive.xls" to open when doing the above, but if so I would like it to close afterwards. Thanks
The File path to "Fmi Saw Archive.xls" is
(The range consist of cells A4,A6,A12,A15,A16,A17)
After copying "Line4" I need it to copy a Range called "Line5" to the next empty row.
(This Range is bascially the same B4,B6,B12,B15,B16,B17)
and so on and so on
I have 21 Different ranges I need to do this with. They are almost the same as mentioned above, just going to the next line.
Im not sure if it is required but to me it is not necessary for "Fmi Saw Archive.xls" to open when doing the above, but if so I would like it to close afterwards. Thanks
The File path to "Fmi Saw Archive.xls" is
Code:
Workbooks.Open Filename:="H:\Burney Table\Fmi Saw Archive.xls"
