Specifying sheets in a different workbook

[Matt]

I have this code to specify the lastrow, can someone help me with the code to specify a sheet in a different workbook.

lastrow = Sheets("Complete").Cells(Rows.Count, "B").End(xlUp).Row

thanks

Matt

 

[Jay Petrulis]

On 2002-04-17 08:23, Matt wrote:
I have this code to specify the lastrow, can someone help me with the code to specify a sheet in a different workbook.

lastrow = Sheets("Complete").Cells(Rows.Count, "B").End(xlUp).Row

thanks

Matt

Hi Matt,

Qualify it with the Workbooks reference. You may need to specify the path, but if the other workbook is open, the following should work.

lastrow = Workbooks("My file.xls").Sheets("Complete").Cells(Rows.Count, "B").End(xlUp).Row

The original reference can be made more complete by using ThisWorkbook.

lastrow = ThisWorkbook.Sheets("Complete").Cells(Rows.Count, "B").End(xlUp).Row

although that is not a requirement.

Bye,
Jay

 

[Matt]

Thanks again for your help Jay