vb macro needed to split excel sheet

venu
04-28-2008, 12:52 AM
--------------------------------------------------------------------------------

Hi All,

I Need A Vb Macro Script To Make Multiple Copies Of Microsoft Excel Sheet After 65 Rows Are Exceeded. Since Am Using Excel It Limits Onl;y 65k Rows.

Can U Please Help Me With Code.


Vb Macro To Break Excel Sheet After It Exceeds 65k Rows
Million Thanks In Advance




Please post Excel questions, in the Excel forum.

Thank you.

Colin Legg
04-28-2008, 05:47 AM
Hi Venu and welcome to the forum! :)

Please re-read the posting guidelines (http://www.xtremevbtalk.com/faq.php?faq=evbf_faq#faq_evbf_rules)which you agreed to when you signed up.

Please also read the How To Participate Here Effectively (http://www.xtremevbtalk.com/showthread.php?t=150438) thread.

Please then rephrase your question giving the necessary details we will require in order to give you some advice on how to achieve your goal. Please post any relevant code which you have produced together with details about the problem you are having. Please note that we do not write code to order here.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum