Search:

Type: Posts; User: Rick Rothstein; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.83 seconds.

  1. Re: VBA to assign letter in cell next to a cell with a number

    Could there be blank cells mixed in with the cells in Column B that have values in them or is the data contiguous?

    When Column B cells have a value, will that value always be a number or could...
  2. Re: VBA Delete current work sheet if not a specific title

    The OP said "delete current work sheet if not a specific name", so I think your equal sign (=) should be a not equal sign (<>).
  3. Replies
    3
    Views
    56

    Re: Split Text in Rows

    This is why single examples are not much help. Do you have data in cells A2, A3, etc.? While your loop's upper limit evaluates to 1 (which means only cell A1 is being processed), your use of a loop...
  4. Replies
    19
    Views
    171

    Re: Remove Columns

    That... I do not know. I mean I do know how to do it (select a column, with the Shift key pressed press the End key followed by the Right Arrow key, then right click a column header letter and select...
  5. Replies
    19
    Views
    171

    Re: Remove Columns

    You do not right click the selection... you right click any letter in the column header (the part of the worksheet with the A, B, C, etc. on it.)
  6. Replies
    8
    Views
    130

    Re: How to split text string in

    Given the OP's example(s) and the location of the desired field so close to the beginning of the text, it is safe to do away with the multiple LEN function calls and use a fixed constant of...
  7. Replies
    15
    Views
    236

    Re: Fluid VBA macro?

    And here I thought you were being facetious. Okay, so then I was right, executing almost entirely in memory was a lot faster. Hopefully the OP comes back to this thread to see this.
  8. Replies
    15
    Views
    236

    Re: Fluid VBA macro?

    Yes! I knew it would be faster!!!! :lol:

    Seriously, though, I thought the combination of an internal VB array coupled with the Dictionary object (that is, processing everything in memory) would...
  9. Replies
    15
    Views
    236

    Re: Fluid VBA macro?

    Fluff,

    If you get the chance to test it, I would be curious how the above code fared speedwise in comparison to the other codes.
  10. Re: vba Odd's and Even"s Array Count If

    Just noting as a point of interest that as an alternative, what I highlighted in red can be replaced with this...

    Ary(r, c) Like "*[02468]"
  11. Replies
    6
    Views
    169

    Re: Avarage grade from two columns

    That yields an average grade of 0.233077 which cannot be right as the average grade when the lowest grade is 2 and the highest grade is 9. I am pretty sure the formula I posted in Message #2 is...
  12. Replies
    6
    Views
    169

    Re: Avarage grade from two columns

    Assuming your data starts on Row 2 where I have assumed Row 1 contains header, I believe (but do not know for sure) that this formula will return the average grade...
    ...
  13. Re: vba Odd's and Even"s Array Count If

    Are you required to use VBA to solve this? If not, you can put these formulas in the indicated cells and copy them down to the end of your data...

    M2: =SUMPRODUCT(--(MOD(B2:G2,2)=1))

    N2:...
  14. Replies
    7
    Views
    162

    Re: Looking for a way to loop this

    I think the code may be able to be simplified a touch more, but in order to decide that, can you tell us what is in the cells of Column E?
  15. Replies
    2
    Views
    66

    Re: For loop through array

    You cannot reference variables by their names stored as text in String variable. If you created an array where each index number was specifically for a given purpose (what you are trying to use the...
  16. Replies
    15
    Views
    236

    Re: Fluid VBA macro?

    I have been completely overlooking the .Value=.Value code line... all this time I thought the goal was to load up Column E with formulas. Since the goal is to place values in the cells, I think this...
  17. Re: how to count streak in range ascending

    It works for me. Explain exactly what you did that led you to believe it did not work.
  18. Re: Formula to round up to the nearest 10 cents

    Just checking... are you sure Eric's formula always gives you the correct value? I ask because your original question was slightly confusing. You said...

    "Is there a formula to round up a number...
  19. Replies
    15
    Views
    236

    Re: Fluid VBA macro?

    Fluff,

    I am not sure on this (it makes no difference mass inserting values into cells), but do you think shutting of calculations (and maybe screen updating) while the formulas are mass inserted...
  20. Re: UDF to sum until certain column is not blank again

    I am not sure why, but you example totals each are $0.01 too small. Anyway, give the following UDF a try...

    Function SumToYes()
    Dim R As Long
    R = Application.Caller.Row + 1
    Do While...
  21. Replies
    9
    Views
    136

    Re: VBA to Separate Values

    If you wanted to save a small amount of typing, you could replace what I highlighted in red with this...

    [{1,2,3,4,5}]
  22. Re: how to get the sum of a range in which two specific if conditions apply

    I missed that last one!!! :banghead:




    Yeah, that is probably what the OP is after.
  23. Re: how to get the sum of a range in which two specific if conditions apply

    Put a space after your < sign, otherwise this forum's interpreter thinks you started and HTML tag.
  24. Re: how to get the sum of a range in which two specific if conditions apply

    Why is the answer 110... shouldn't it be 100? The 10 you from the first line violates your "and a is greater than 30" rule, so why are you counting it?
  25. Re: How return built-in constant value from its name

    I am pretty sure you cannot retrieve the value directly as, to my understanding, all constants are replaced by their value at the time the code is compiled (which is before the code itself physically...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4