Posts by big02

    This may be a little off topic, but i have a data series that i am trying to get the log normal standard deviation for. Ive tried using the lognormdist function but am unsure how to derive the standard deviation from there. If anybody has an idea for this please let me know.


    Thanks

    Thanks WillR -
    i tried your suggestions and i still could not speed it up.


    unfortunatly i am running a 450 processor so that is probably somewhat the cause.


    I can narrow the range down to 250 rows so that should at least speed it up by 2.


    Thanks everyone for your input. I appreciate the help on this board.

    Thanks for the replies. I actually had that part in the code but it still was really slow. I'm not sure if it's just excel trying to clear the format in each cell individually. The weird thing is that after i run the macro once it works fine.


    The first part of the code is listed below.
    When i first run the code - after about 4 minutes of stalling i break the code and it usually is stopped at the valuation sheet.


    Should i name the ranges before clearing them?


    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual
    Application.CutCopyMode = False
    Worksheets("Output").Range("a5:d500").ClearContents
    Worksheets("Calculations").Range("b5:d500").ClearContents
    Worksheets("Calculations").Range("m5:m500").ClearContents
    Worksheets("Valuation").Range("b5:t500").ClearContents
    Worksheets("Performance").Range("b5:t500").ClearContents
    Worksheets("Growth").Range("b5:t500").ClearContents
    Worksheets("Estimates").Range("b5:t500").ClearContents
    Worksheets("Output Printable").Range("b5:s500").ClearContents
    Worksheets("Output Printable").Range("b5:s500").ClearFormats
    Application.CutCopyMode = True
    Application.Calculation = xlCalculationAutomatic

    Hello all,
    1st time post - long time reader


    My question:
    when i put in the code
    Worksheets("Name of Sheet").Range("m5:m500").ClearContents
    It takes forever to run.
    Is there a simpler/faster way to code what i want? Ive tried .clear and .delete with no progress.


    Thanx for the replies
    BTW - this happens in excel 97 and above