LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default General ?? regarding Macro or Module size in a spreadsheet

Any comments regarding how a 3 or 4 line macro would substantially
contribute to enlarging a spreadsheet workbook?

Through the help of this NG and sources, I was able to use a macro in a
spreadsheet that would hide columns of data that were blank.
This sheet was submitted to be incorporated in a workbook with approximately
5 other tabs or worksheets.
The person responsible for doing this omitted this macro stating the reason
was they were trying to keep the footprint or size of the workbook small.
Several people I demonstrated the macro to thought it would help them
immensely and they are soon to find out it is not there.

I honestly don't know enuf about modules, placement, and macro size to
understand if this reasoning is sound or not. The lines in the macro
amounted to less than 3 or 4, much less than this post alone. It could be
perhaps it conflicted with another worksheet, but I am only guessing. My
thoughts, I hope unwarranted, are this person simply didn't want to take the
time to incorporate it completely.
Comments?


 
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
General ledger spreadsheet continued Mark C[_2_] Excel Worksheet Functions 1 June 20th 09 03:32 AM
General ledger spreadsheet Mark C[_2_] Excel Worksheet Functions 3 June 19th 09 06:27 PM
general questions regarding reducing file size for pivottables Marcus Ahlbäck Excel Discussion (Misc queries) 0 October 31st 07 07:58 AM
General protection fault in module HPPCL5F4.DLL at 0002:000006c2. Ben Excel Discussion (Misc queries) 1 January 4th 05 12:05 AM
size of module JohnE Excel Programming 2 November 7th 03 08:11 PM


All times are GMT +1. The time now is 03:42 AM.

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

About Us

"It's about Microsoft Excel"