View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
psk[_6_] psk[_6_] is offline
external usenet poster
 
Posts: 1
Default How can i handle more than 65000 rows in excel


Hi,
I have written Some macros in Business objects to export to exce
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 openin
workbook and sheet ..like that ..to split into sheets if it exceed
65000 and put it another one in the same workbook . Thank

--
ps
-----------------------------------------------------------------------
psk's Profile: http://www.excelforum.com/member.php...fo&userid=1573
View this thread: http://www.excelforum.com/showthread.php?threadid=27436