Posted to microsoft.public.excel.programming

BinhNT

external usenet poster

Posts: 1

Unspecify Error in Range count

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/

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Worksheet Functions	1	May 3rd 08 02:35 PM
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Discussion (Misc queries)	1	May 3rd 08 10:52 AM
Multiple Criteria, Count If, Sum Product to get count across range	Jonathan	Excel Worksheet Functions	5	January 9th 08 11:32 PM
How to count dates within a certain range in a column with mutiple date range entries	Krisjhn	Excel Worksheet Functions	2	September 1st 05 01:59 PM
Count cells in one range based on parameters in another range	dave roth	Excel Worksheet Functions	2	March 29th 05 05:33 PM

All times are GMT +1. The time now is 10:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us