Results 1 to 7 of 7

I have 14,900 Lines of code in my Sub, Could someone show me how to be more efficient?

Threaded View

BoBoCoDeR I have 14,900 Lines of code... 05-07-2012, 12:02 AM
StevenM Re: I have 14,900 Lines of... 05-07-2012, 04:05 AM
StevenM Re: I have 14,900 Lines of... 05-07-2012, 05:11 AM
StevenM Re: I have 14,900 Lines of... 05-07-2012, 05:38 AM
StevenM Re: I have 14,900 Lines of... 05-07-2012, 06:08 AM
Marcol Re: I have 14,900 Lines of... 05-07-2012, 07:04 AM
shg Re: I have 14,900 Lines of... 05-07-2012, 08:29 AM
  1. #1
    Registered User
    Join Date
    05-06-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post I have 14,900 Lines of code in my Sub, Could someone show me how to be more efficient?

    I am sure the entire Sub does exactly what I need it to do except for the fact the compiler said No Way! It is too large to compile.
    I have 14,900 lines of code.

    I am not asking for some fish.
    I am looking for some one to teach me how to fish here.

    I am sure there is a way I could use a clever loop here to get this down a few thousand lines of code.
    Loops are not unfamiliar to me as you could see if you peaked at my other modules I have codded.
    But in the instance of this Sub I had a hard time seeing the logic to do what I needed to be done any other way then I did it.

    I would post the code here but that would be insane as there is 14,900 lines of it.
    While that is a lot of code. I promise it is all very easy to follow and straight forward what I am trying to do.
    I will upload the Entire Workbook.
    The sub I have issue with is
    Module5
    Sub UpdateDaily()

    Basically what this does is it takes values from the first sheet and based upon what day of the week it is copies that data to the appropriate sheet under the appropriate day of the month.

    Any help given would surely take my programming up a notch.
    I thank you in advance for your time.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1