Sounds like the sheet name may be wrong.
Try to isolate the error..
break it out & see where the error comes

WITH Workbooks("convert").Sheets("CNV").
MyRow = .Range("A65000").End(xlUp).Row
END WITH

Note that there are no brackets round Row
.Row
not
.Row()


Patrick Molloy
Microsoft Excel MVP




-----Original Message-----
I have the error with this statement:

MyRow = Workbooks("convert").Sheets("CNV").Cells(65536,
1).End(xlUp).Row()

The error "Subscript out of range". event it has been OK
for running
thousand times before. I have remove Exel XP and
reinstall it but it
still have error. Now, I use Office2003 but everything
can not work.
May be it came from some update of my WindowsXP, but I
have reinstall
my WindowsXP already.

Could you help me to solve this? Thanks much!


---
Message posted from http://www.ExcelForum.com/

.