Cells(my_crt_row,my_crt_col+1) crashes for my_crt_row65536

Posted to microsoft.public.excel.programming

BEDE[_4_]

external usenet poster

Posts: 3

Cells(my_crt_row,my_crt_col+1) crashes for my_crt_row65536

I tried this in Excel 2007, where the worksheets may have 1M rows.
Why does this crash?
In Excel 2000 to 2003, this thing worked fine for my_crr_row<=65536, as I
expected. But now, having more rows in a sheet, why does this not work for a
larger row number?

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
Excel 2007 crashes on entering data in a specific range of cells	Sunny Dacat	Excel Discussion (Misc queries)	1	September 12th 08 01:16 PM
Visible automated Excel: automation crashes if user selects cells, protection?	Christian Friedrich	Excel Programming	1	November 3rd 06 04:26 AM
Excel crashes as soon as I try to format cells?	Mike	Excel Discussion (Misc queries)	0	May 19th 06 06:17 PM
Excel warning "too many different types of cells", then crashes..	Agotro	Excel Programming	2	February 17th 06 06:05 AM
Copy row, Insert>Copied>Cells crashes Excel	Kent	Excel Discussion (Misc queries)	0	April 26th 05 10:48 PM

All times are GMT +1. The time now is 02:26 PM.

Menu

About Us