Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default limit on size of macro for excell97

Hi
Does anyone know if there is a limit on the size of a macro in Excel 97.
The reason i ask is that when i get to a certain point in writing a
macro, excel bombs when i try to load the spread sheet containing the
macro. If i just paste the macro in from a copy i made in word, excel
works fine. It's only when i try to load the spread sheet that i get an
error which causes excel to close and try to send an error message to
Microsoft

"
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27,285
Default limit on size of macro for excell97

There isn't a published limit, but it is often said that if you export the
module and look at its size, if it is approaching 64K, then you should
probably slit it. Of couse it shouldn't be a big deal to split it, so you
might try that anyway - that is if it isn't some long macro recorder type
single subroutine.

--
Regards,
Tom Ogilvy


"Joe Farruggio" wrote in message
...
Hi
Does anyone know if there is a limit on the size of a macro in Excel 97.
The reason i ask is that when i get to a certain point in writing a
macro, excel bombs when i try to load the spread sheet containing the
macro. If i just paste the macro in from a copy i made in word, excel
works fine. It's only when i try to load the spread sheet that i get an
error which causes excel to close and try to send an error message to
Microsoft

"



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
File size limit Daniel Excel Discussion (Misc queries) 4 September 4th 06 06:50 AM
Cell size? Or size limit for Text data type? CClem Excel Discussion (Misc queries) 0 April 21st 06 04:09 PM
limit size of worksheet abfabrob Excel Discussion (Misc queries) 7 February 22nd 06 06:04 PM
Trouble copying worksheets between books - is there size limit? kris2u Excel Worksheet Functions 2 October 13th 05 08:44 PM
Is there a size limit for putting a excel webpage online? [email protected] Excel Discussion (Misc queries) 0 March 3rd 05 03:57 PM


All times are GMT +1. The time now is 11:24 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"