try explicitly naming the workbook and worksheets ... you can't always be
sure workbooks(1) referes to the correct book.
same with worksheets
in my test "sheet3" was actually sheet(1) so it returned 1 as well.

when opening workbooks you get better control using a workbook object

dim wb as workbook
set wb = workbooks.open({file})

r = wb.Sheets("sheet1").Range("A1").CurrentRegion.Rows .Count
wb.Close false ' closes without saving






"Dave" wrote:

Hi,

I am having an issue when I try to counts rows in two separate workbooks. I
am not sure if this is a bug or me. Any assistance would be greatly
appreciated.

In workbook(1)Sheet(1), r is coming up with 1 row when there are actually 64
rows
In workbook(2)sheet(1) s is coming up with 55 rows which is correct.

r = Workbooks(1).Sheets(1).Range("A1").CurrentRegion.R ows.Count
s = Workbooks(2).Sheets(1).Range("A1").CurrentRegion.R ows.Count

I am not sure if I am providing enough information. This code used to work
but has just stopped working yesterday. We are using excel 2003.
--
Thank you

Dave