A pathetic question

M

Mike W

In my Personal.xls workbook I have 49 macros contained in 44 modules.

Some modules contain up to 4 different macros (why is that?) whilst others
(presumably where macros have been deleted) are empty, and, as I am an
inveterate tidyer upper, I would like to know if I can delete these empty
modules and is it worth cutting and pasting to finish with a sequential
number of modules.

Sad I know but I do like things tidy if poss.

Thanks,

Mike
 
B

Bob Phillips

You can delete the empty modules no problem.

Best to group like type macros in separate modules, not all in one.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Don Guillett

By all means, remove the empty modules and organize as desired. Just don't
put too many procedures in one module. Also nice to name them in the
properties area.
 
M

Mike W

thanks very much gents, I'll start to tidy it up now, making a backup copy
of personal.xls first of course.

Mike
 
A

Alan Beban

Don said:
By all means, remove the empty modules and organize as desired. Just don't
put too many procedures in one module. . . .
Click to expand...

Why is that?

Alan Beban
 
K

Ken Wright

Hi Alan - Cribbed from a post some time ago that Tom answered:-

What is there to explain? If you export a module as a file, then look at
the file size, it if it greater than 64KB, then, based on Rob's experience
and that of others, one may experience strange problems with the
application.

Since this is not a documented restriction, it would be hard to definitively
say what the exact restrictions are, but I would suggest that as a rule of
thumb, regardless of the type of module, keep the size to less than 64 KB.

--
Regards,
Tom Ogilvy


Stuart said:
Within the last day or so Rob Bovey replied to an OP
and included the comment that (sic) "a module should
not exceed 64kb" ( I think that's what was said).

Would someone be kind enough to explain the reasons
behind this advice, please?

Would this apply to all modules (Standard, Class etc),
and would this equally apply to AddIns?

Regards.
Click to expand...
Click to expand...

Regards
Ken...................
 
A

Alan Beban

Thanks, Ken. Do you know what newsgroup the thread was in, or what the
subject was, so that I can more easily Google it?

Thanks for responding,
Alan Beban

Ken said:
Hi Alan - Cribbed from a post some time ago that Tom answered:-

What is there to explain? If you export a module as a file, then look at
the file size, it if it greater than 64KB, then, based on Rob's experience
and that of others, one may experience strange problems with the
application.

Since this is not a documented restriction, it would be hard to definitively
say what the exact restrictions are, but I would suggest that as a rule of
thumb, regardless of the type of module, keep the size to less than 64 KB.

--
Regards,
Tom Ogilvy


Within the last day or so Rob Bovey replied to an OP
and included the comment that (sic) "a module should
not exceed 64kb" ( I think that's what was said).

Would someone be kind enough to explain the reasons
behind this advice, please?

Would this apply to all modules (Standard, Class etc),
and would this equally apply to AddIns?

Regards.
Click to expand...
Click to expand...

Regards
Ken...................


Why is that?

Alan Beban
Click to expand...
Click to expand...
 
H

Harlan Grove

Alan Beban wrote...
Thanks, Ken. Do you know what newsgroup the thread was in, or what the
subject was, so that I can more easily Google it?
Click to expand...
....

So you also need introductory level Google Groups searching?

Google Groups advanced search provides an option to match an exact
phrase in a newgroup posting. Using the following phrase lifted from
Ken's response,

"it if it greater than 64KB, then, based on Rob's experience"

as the exact phrase to match in *excel* newsgroups, Google produces
exactly two threads, this one and

http://groups.google.com/group/micr...6225e164f83/56d79968f16737ed#56d79968f16737ed

(or http://makeashorterlink.com/?O1FD21DAB ).
 
Top