hi,
i have this
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
That is really strange.
I'm trying to count how many rows there are in a Column
i have this
wherenumRows1 = wb1.Sheets("daily1").Range(pIndex1 & Sheets("daily1").Rows.Count).End(xlUp).Row
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
The variable are different.numRows2 = wb2.Sheets("daily2").Range(pIndex2 & Sheets("daily2").Rows.Count).End(xlUp).Row
That is really strange.
I'm trying to count how many rows there are in a Column