hi all,
Ok i think this should be a fairly simple question for you lot.
I need to know how to reference another workbook
ie WorkbookA - SheetA = WorkbookB - SheetB so far i have this:
([WorkbooknameA.xls]. Worksheets ("WorksheetnameA")=([WorkbooknameB.xls]. Worksheets ("WorksheetnameB")
I hope i have made this clear as to what im looking for here.Heres my actual code
LastRow = Workbooks("Prelim 26 Sept 2006.xls").Worksheets("Prelim 19 Sept 2006").UsedRange.Rows.Count
Ok i think this should be a fairly simple question for you lot.
I need to know how to reference another workbook
ie WorkbookA - SheetA = WorkbookB - SheetB so far i have this:
([WorkbooknameA.xls]. Worksheets ("WorksheetnameA")=([WorkbooknameB.xls]. Worksheets ("WorksheetnameB")
I hope i have made this clear as to what im looking for here.Heres my actual code
LastRow = Workbooks("Prelim 26 Sept 2006.xls").Worksheets("Prelim 19 Sept 2006").UsedRange.Rows.Count