problem with more than 1 module - count a row- why?

[earp_]

hi,
i have this

numRows1 = wb1.Sheets("daily1").Range(pIndex1 & Sheets("daily1").Rows.Count).End(xlUp).Row

where
Dim wb1As Workbook
Set wb1= Workbooks("myFile.xls")
now, this works fine if there is only one workbook opened!
Instead if I have two workbooks opened it says out of range!
any suggests?!
The second workbook is

numRows2 = wb2.Sheets("daily2").Range(pIndex2 & Sheets("daily2").Rows.Count).End(xlUp).Row

The variable are different.
That is really strange.
I'm trying to count how many rows there are in a Column

 

[earp_]

Re: count a row- why?

Hi, it seems I have some problems with this

numRow = wb.Sheets("daily").Range(pIndex & Sheets("daily").Rows.Count).End(xlUp).Row

Does anyone can suggests me a different way to count a column?

 

[Norie]

Re: count a row- why?

Remove Sheets("daily1").

numRow = wb.Sheets("daily").Range(pIndex & Rows.Count).End(xlUp).Row

 

[earp_]

i found also this

myNum = WorksheetFunction.Count(Range(pIndex & "1").EntireColumn)

the 1 means that it starts from the first row right?
instead if I want it to start from the row 2, i just need to put 2 or write
new = myNum - 1, right?

 

[Norie]

New problem/question - new thread.