Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.16 seconds.

  1. Assuming you're not worried about formulas: ...

    Assuming you're not worried about formulas:


    Sub TrimIt()
    with range("B4:L100")
    .value2 = Evaluate("INDEX(Trim(" & .Address(0,0) & "),,)")
    End With
    End Sub
  2. Replies
    1
    Views
    102

    For reference, cross-posted here:...

    For reference, cross-posted here: http://www.vbaexpress.com/forum/showthread.php?53041-Poor-display-in-listbox
  3. Replies
    5
    Views
    382

    Only in Access - it's not a native VBA function.

    Only in Access - it's not a native VBA function.
  4. [SOLVED] FYI, you really don't need the Format there: ...

    FYI, you really don't need the Format there:

    Range("F" & lStartRow & ":W47")
    will do. I suspect the original code needs to alter the sort key range too.
  5. Replies
    10
    Views
    182

    Sterling work, chaps.

    Sterling work, chaps.
  6. Replies
    5
    Views
    382

    You can have arrays of arrays, yes. If you...

    You can have arrays of arrays, yes.

    If you need to access a variable by name, you can use a class or you can use something like a Collection or Dictionary which allows you to use a string as the...
  7. Correct. :) Note: with the advanced filter I am...

    Correct. :) Note: with the advanced filter I am talking about a two cell criteria range, not a formula for each row of the table (the advanced filter effectively does that for you).
  8. Replies
    17
    Views
    283

    I grouped the Time field. If you recreate the...

    I grouped the Time field. If you recreate the pivot, it will use the same cache by default, so you will get the same groupings.
  9. Replies
    17
    Views
    283

    You could also use a pivot table. (See attached)...

    You could also use a pivot table. (See attached) You just need to group the Time field by hours.
  10. Replies
    18
    Views
    403

    I assume you mean for each textbox, rather than...

    I assume you mean for each textbox, rather than cell? Typically you would use a class module and a WithEvents variable for multiple controls that need the same event code but unfortunately...
  11. Replies
    13
    Views
    300

    I know - they always seem puzzled when I refuse....

    I know - they always seem puzzled when I refuse. :)
  12. Yes, I think you have. You want an array of...

    Yes, I think you have. You want an array of distinct values - there's no point repeating any.



    You could, but autofilter is easy.



    No you don't - you can use a two cell criteria range...
  13. Use code to loop through the data building up a...

    Use code to loop through the data building up a list of valid actual values, then use that array in the autofilter.
  14. Replies
    13
    Views
    300

    Pie charts are generally inappropriate choices....

    Pie charts are generally inappropriate choices. Trying to compare 2 pie charts is just evil. The mere fact that you have to label all the points for the chart to really tell you anything is a good...
  15. Replies
    2
    Views
    88

    I'm not entirely clear what you want in the cell...

    I'm not entirely clear what you want in the cell but I imagine a variation of this custom number format:
    h" hours" mm "minutes"
  16. Replies
    11
    Views
    260

    And which version of Excel?

    And which version of Excel?
  17. Thread: Excel SUM formula

    by rory
    Replies
    5
    Views
    144

    If you have 2007 or later, you just use:...

    If you have 2007 or later, you just use:
    =IFERROR(your current formula,0)
  18. Thread: Excel SUM formula

    by rory
    Replies
    5
    Views
    144

    You can use SUMIF: =SUMIF(somerange,"#VALUE!")...

    You can use SUMIF:
    =SUMIF(somerange,"<>#VALUE!")
    or add some error handling so the formulas return 0 or "" instead of #VALUE!
  19. Replies
    26
    Views
    827

    I'd start here:...

    I'd start here: https://www.microsoft.com/en-gb/download/details.aspx?id=40326
  20. Replies
    8
    Views
    6,021

    Have you tried creating a template email with the...

    Have you tried creating a template email with the signature already present and then using to create the mailitem rather than just creating a blank one?
  21. Replies
    5
    Views
    116

    [SOLVED] I think your description was inverted from the...

    I think your description was inverted from the logic you wanted:
    =IF($A$4 =0,$F$4,IF($E$4=C4,B4,""))
  22. Replies
    5
    Views
    116

    [SOLVED] =IF($E$4=C4,B4,if($A$4 ="0",$F$4,""))

    =IF($E$4=C4,B4,if($A$4 ="0",$F$4,""))
  23. Open the Object Browser (press f2) and select...

    Open the Object Browser (press f2) and select Range from the list of classes. You will then see all its properties/methods/events listed.
  24. Replies
    15
    Views
    402

    [SOLVED] In that case, just: =WORKDAY(EOMONTH(A11,0)+1,-1)

    In that case, just:
    =WORKDAY(EOMONTH(A11,0)+1,-1)
  25. Replies
    15
    Views
    402

    [SOLVED] It would be simpler if you could use an actual...

    It would be simpler if you could use an actual date cell (you could have the other two cells calculate off that), but assuming your computer recognises text like "01 January 2015" as a date, you can...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4