#1   Report Post  
TKO II
 
Posts: n/a
Default Excel Macros

I've created a macro on an existing worksheet and when I run it I get:
Compile Error: Procedure to large. How do I combine this macro into two
macros without the hours I spent originally?
  #2   Report Post  
StinkeyPete
 
Posts: n/a
Default

Cut out logical pieces of the code and make them sub procedures and then call
the sub procedures in your main code. (Insert Procedure)

"TKO II" wrote:

I've created a macro on an existing worksheet and when I run it I get:
Compile Error: Procedure to large. How do I combine this macro into two
macros without the hours I spent originally?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Executing of excel Macros. KarthikK Excel Discussion (Misc queries) 4 June 28th 05 12:00 PM
help with excel (maybe macros) laskuh Excel Worksheet Functions 1 March 20th 05 12:03 PM
How do I update Excel 2000 macros to work in Excel 2002? BobPetrich Excel Discussion (Misc queries) 3 January 4th 05 04:06 PM
how can i edit excel 4 macros in Excel 2003 Pedrito1967 Excel Worksheet Functions 0 December 7th 04 07:21 PM


All times are GMT +1. The time now is 01:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"