Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

VBA Max Line Limit

  Asked By: Cameron    Date: Dec 14    Category: MS Office    Views: 1629
  

This is a new one for me... Thought I'd pass it on.

exceltips.vitalnews.com/.../..._Limit_for_a_Macro.
html

Anyone know of similar limits for Word and Access???

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Della Simpson     Answered On: Dec 14

I have run into a similar limit  in Access, so my guess is that it holds true
for Word, Outlook and PowerPoint. The way I got around it was to create a
second module and call it from the first. (have a big hairy Select Case
process that runs in Access calling various Word templates.)

 
Answer #2    Answered By: Devrim Yilmaz     Answered On: Dec 14

Yeah... That should work. Thanks Dawn. I just didn't know there was *any*
limit!!

It's a good thing I try and "modularise" my code because I'm sure I'd hit
the limit  otherwise....

 
Didn't find what you were looking for? Find more on VBA Max Line Limit Or get search suggestion and latest updates.




Tagged: