how can i increase number of rows beyone 65536 in excel sheet

's Computer Specifications

the maximum of number of rows that are available in an excel sheet are only
65536,i would like to enhance it to my choice. Plase mail me how can i do it
,either by writing a macro , or other way. please also mail me the entire
procedure, where to correct and where to run the macro etc.

's Computer Specifications

You want the car washed and the dog taken out as well?
There is no way of extending this, use a database or multiple sheets

--
Regards,

Peo Sjoblom

"increasing number of rows in excel sheet" <increasing number of rows in
excel (E-Mail Removed)> wrote in message
news:5F6BA550-0107-4E08-BB3C-(E-Mail Removed)...
> the maximum of number of rows that are available in an excel sheet are
> only
> 65536,i would like to enhance it to my choice. Plase mail me how can i do
> it
> ,either by writing a macro , or other way. please also mail me the entire
> procedure, where to correct and where to run the macro etc.
>

's Computer Specifications

Don't think there's any way to do this <g>
The 65536 rows is a limitation in Excel
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"increasing number of rows in excel sheet" <increasing number of rows in
excel (E-Mail Removed)> wrote in message
news:5F6BA550-0107-4E08-BB3C-(E-Mail Removed)...
> the maximum of number of rows that are available in an excel sheet are
only
> 65536,i would like to enhance it to my choice. Plase mail me how can i do
it
> ,either by writing a macro , or other way. please also mail me the entire
> procedure, where to correct and where to run the macro etc.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do i increase the rows in a excel balance sheet?	=?Utf-8?B?ZGFzcw==?=	Microsoft Excel New Users	5	18th May 2007 12:40 PM
Can I put more than 65536 rows in one Excel sheet?	=?Utf-8?B?T2ZmaWNlIHVzZXI=?=	Microsoft Excel Worksheet Functions	2	26th Sep 2005 11:08 PM
Excel should accomodate more number of rows than 65536, to load l.	=?Utf-8?B?TGF4bWFuIENoYXJpcGFsbHk=?=	Microsoft Excel Misc	1	22nd Apr 2005 09:41 PM
Can I increase row capacity beyond 65536 rows	=?Utf-8?B?VHJpc2g=?=	Microsoft Excel Worksheet Functions	2	23rd Feb 2005 11:15 PM
How increase max # of rows/sheet in excel?	=?Utf-8?B?SkthbGxlbg==?=	Microsoft Excel Misc	1	20th Dec 2004 08:31 PM