Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.87 seconds.

  1. Replies
    8
    Views
    78

    Re: Target.Column + 8?

    FYI, Mac users can use userforms. (they just can't build them if they use a version later than 2011)
  2. Re: How to split units from numbers stored in a cell that is custom formatted

    If the units are only part of the custom format, you'd need code to retrieve them - do you need them, or the quantities, or both?
  3. Re: Determining RGB values of each item in the Standard Color Palette

    Do you mean something like this:


    Sub colourList()
    Dim n As Long
    For n = 1 To 56
    With Cells(n, "A")
    .Value2 = ActiveWorkbook.Colors(n)
    .Interior.Color =...
  4. Replies
    4
    Views
    68

    Re: Subtotal in the last row of table

    If you mean using the 'Total Row' option on the Design tab of Table tools, then that behaviour shouldn't occur. If you just typed the formulas in, then Excel defaults to assuming it's just a row of...
  5. Replies
    4
    Views
    68

    Re: Subtotal in the last row of table

    Did you add a Totals row to the table, or just add the formulas as a new row?
  6. Replies
    9
    Views
    203

    Re: Cell Format Include a Footnote

    I don't understand this comment. The format applies to the returned value so in your example it would show the formula result with a superscript 1 after it.
  7. Replies
    9
    Views
    222

    Re: Runtime error 424 Object Required

    I can't download files at work I'm afraid.
  8. Replies
    9
    Views
    222

    Re: Runtime error 424 Object Required

    Are they in the same workbook as the code?
  9. Replies
    9
    Views
    222

    Re: Runtime error 424 Object Required

    That error would suggest that one (or both) of those codenames is incorrect (or in a different workbook to the code).
  10. Replies
    7
    Views
    51

    Re: Search and Replace custom function issue

    You're going to need a loop of some kind. I suggest you load the range into an array and loop through that, then write the array back to the sheet.
  11. Replies
    7
    Views
    51

    Re: Search and Replace custom function issue

    Is Col_AnimalType more than one cell?
  12. Re: Formula for if number is 7 or higher to add 'Fully Utilised' in a cell

    Glad to help. :)
  13. Re: Formula for if number is 7 or higher to add 'Fully Utilised' in a cell

    You can use:


    If (Cells(rw, "M").Value >= 7 Or Cells(rw, "N").Value >= 7) And Cells(rw, "O").Value <> "Fully Utilised" Then Cells(rw, "O").Value = "Fully Utilised"
  14. Re: Formula for if number is 7 or higher to add 'Fully Utilised' in a cell

    Do you mean if either M or N is more than 7, or if the total is more than 7? (or something else)
  15. Re: VBA - What variable types should be manually unloaded at the end of a macro

    It depends on their scope. If they are local to the procedure they are used in, they will be cleared at the end anyway, so you don't need to do anything. If they are module level or public, and you...
  16. Replies
    7
    Views
    157

    Re: Excel question: Conditional formatting transparent color

    You could also just apply a pattern using CF so that you can see that CF applies while still seeing the fill colour.
  17. Thread: With command

    by RoryA
    Replies
    4
    Views
    48

    Re: With command

    Not exactly, no! Think of it more like an implicit variable.
  18. Thread: With command

    by RoryA
    Replies
    4
    Views
    48

    Re: With command

    The With statement holds a reference to Cells(1, 1). You then delete that entire block of cells, so the reference is invalid from that point on, but you then try to resize it, which causes the error....
  19. Re: Combox properties missing (Linked cell, Listfield range)

    The listfillrange must be either the address of a range, or the name of one.
  20. Re: Formula for if number is 7 or higher to add 'Fully Utilised' in a cell

    Glad to help. :)
  21. Re: Formula for if number is 7 or higher to add 'Fully Utilised' in a cell

    You'd need worksheet_calculate if they are formulas. Something like this:


    private sub worksheet_calculate()
    application.enableevents = false
    dim rw as long
    for rw = 2 to 17
    if cells(rw,...
  22. Re: Formula for if number is 7 or higher to add 'Fully Utilised' in a cell

    If O2:O17 are manually entered, rather than formulas, you'd just use a Worksheet_Change event to update the corresponding cells in M when the values are changed.
  23. Replies
    2
    Views
    27

    Re: AVERGEIFS and OR formula

    You could use:

    =SUM(SUMIFS('Sales History'!T:T,'Sales History'!B:B,A8,'Sales History'!C:C,{"Surrendered","Current"}))/SUM(COUNTIFS('Sales History'!T:T,'Sales History'!B:B,A8,'Sales...
  24. Re: Formula for if number is 7 or higher to add 'Fully Utilised' in a cell

    Only using code.
  25. Re: Formula for if number is 7 or higher to add 'Fully Utilised' in a cell

    =IF(O2>=7,"Fully utliised","")

    and copy down.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4