Search:

Type: Posts; User: shg; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.59 seconds.

  1. Replies
    19
    Views
    438

    Re: Workbook_Change stopped working !

    Can you post your code?
  2. Replies
    19
    Views
    438

    Re: Workbook_Change stopped working !

    And ...?
  3. Replies
    19
    Views
    438

    Re: Workbook_Change stopped working !

    The code in post 1 contains no error handling.
  4. Replies
    19
    Views
    438

    Re: Workbook_Change stopped working !

    I think repairing Excel is a waste of time, and your problem would go away if you put in some error handling and figured out what's causing the problem.
  5. Replies
    19
    Views
    438

    Re: Workbook_Change stopped working !

    Chances are, you have a run-time error so events are not being re-enabled.

    Whenever you diasble events, you should have an error handler (On Error Goto ...) to make sure they are.
  6. Replies
    16
    Views
    265

    Re: generate a random number to enter in a cell

    Excel 2010 ..., and the first Debug.Print was entered after testing.
  7. Replies
    16
    Views
    265

    Re: generate a random number to enter in a cell

    Excel 2101 W7:


    Option Explicit

    Sub RandVsRnd()
    Const n As Long = 10000000
    Dim i As Long
    Dim fT As Single
  8. Replies
    16
    Views
    265

    Re: generate a random number to enter in a cell

    [rand()]
  9. Replies
    16
    Views
    265

    Re: generate a random number to enter in a cell

    It's superior only in speed and the ability to initialize it.

    It's useless for generating unpredictable random sequences (e.g., dice rolls), because after observing a few rolls (maybe 20), it's...
  10. Replies
    16
    Views
    265

    Re: generate a random number to enter in a cell

    Lots.

    The VBA Rnd() function is about 1000 times faster in VBA than WorksheetFunction.Rand.

    Rnd() has a very short cycle (2^24). In Excel 2007, RAND() used a linear congruential generator with...
  11. Re: Why is this code producing R/T 448 - Argument not found

    You're welcome.
  12. Re: Why is this code producing R/T 448 - Argument not found

    E.g.,


    Range("A1").CurrentRegion.AutoFilter ...
  13. Re: Why is this code producing R/T 448 - Argument not found

    AutoFilter is a Range method, not a Worksheet method.
  14. Re: Issues with assigning value to variable and passing between subs

    A textbox by definition contains text. IsNumeric tells you whether the text can be converted to a Double.
  15. Re: Issues with assigning value to variable and passing between subs

    NoCCAdd and noCTot are variant/string when assigned to the textbox contents. Declare them instead as Double, or be explicit in type conversion:


    If IsNumeric(TextBox1) Then NoCAdd =...
  16. Re: How to Convert an Exponential Trendline Equation to a Formula

    If you are fitting an exponential trendline on a line graph, the x values are the categorical series {1,2,3,...}
  17. Thread: Speed Up My Code

    by shg
    Replies
    3
    Views
    60

    Re: Speed Up My Code

    Low-hanging fruit: Replace the loop with


    Range(Rows(2), Rows(finalrow)).RowHeight = 30
  18. Replies
    8
    Views
    154

    Re: Dividing to find an integer

    A
    B
    C
    D
    E
    1
    Delta H
    Steps
    Rise/Step
  19. Replies
    2
    Views
    123

    Re: SKUs not sorting by numerical order

    You could use a small user-defined function:


    A
    B
    C
    1
    Input
    Sort
  20. Replies
    6
    Views
    220

    Re: Round up time by quarter of the hour in VBA

    Significantly slower.
  21. Replies
    6
    Views
    220

    Re: Round up time by quarter of the hour in VBA

    Sub Mux()
    Dim cell As Range
    Dim r As Range

    Set r = FindAll("Match", Columns(3))
    If Not r Is Nothing Then
    For Each cell In r
    cell.Offset(, 4).Value =...
  22. Replies
    6
    Views
    220

    Re: Round up time by quarter of the hour in VBA

    How about just a formula?


    C
    D
    E
    F
    G
    H
    3MATCH
  23. Replies
    3
    Views
    132

    Re: calculating progress of Time or Date

    Basic linear interpolation:

    Pct Complete = (now - begin) / (end - begin)

    The period of performance is (end - begin) and the current state is (now - begin).

    If you get on I-35 in Austin at...
  24. Replies
    3
    Views
    132

    Re: calculating progress of Time or Date

    = (today() - A2) / (C2 - A2)
  25. Re: Why is my custom function referencing the wrong column values?

    If LookupColumn.Cells(r).Text = ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4