Hi psk,

I do NOT know about "Business Objects" but in Excel you could use something like :-

If N = 65001 Then

N = 1

ActiveCell.Offset(-65000, 1).Select

Hope this Helps.
All the Best
Paul



"Jim Thomlinson" wrote in message ...
The best way that I know of to make Excel get around the 65,000 row limit is
to dump the output into Access or something similar and then to either:

-query a result set into excel

-or to use a pivot table externally linked to the data. (I have
successfully linked to over 650,000 records in an Excel pivot table with
remarkably good performance)

"psk" wrote:


Hi,
I have written Some macros in Business objects to export to excel
sheet ..How can i handle if the output exceeds 65000 rows ..


This is the code we use in BO , But how can i handel i mean opening
workbook and sheet ..like that ..to split into sheets if it exceeds
65000 and put it another one in the same workbook . Thanks


--
psk
------------------------------------------------------------------------
psk's Profile: http://www.excelforum.com/member.php...o&userid=15738
View this thread: http://www.excelforum.com/showthread...hreadid=274369