Referencing worksheet in another workbook

[jbfluor]

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

 

[Harvey]

can you post the exact code you are using, and the names of the workbooks?
I assume you have them both opened when your code is executed?
You can send me your workbook with pm, but you need to be very fast then, because I'm here for only 20 minutes more.