Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.32 seconds.

  1. Re: I'd like to count cells with TRUE value in conditional formatting

    You would need to create a formula that replicates all the relevant CF rules.
    Otherwise it would need a macro, as a UDF won't work as that cannot see CF formats, but you would need to trigger the...
  2. Replies
    5
    Views
    98

    Re: Vlookup and match?

    Glad to help & thanks for the feedback
  3. Re: Change format of userform textbox to currency

    Are you entering data into the textbox, or just pulling data from the sheet?
  4. Replies
    3
    Views
    90

    Re: Order of Union Range merging

    If the rows are contiguous, you could use an array to collect the data & then copy that to another sheet for the chart.
  5. Re: Auto save and close query on a "Macro enabled" spreadsheet

    Why not just add
    ThisWorkbook.close Trueto the end of your macro.
    That will close & save the workbook.
  6. Replies
    9
    Views
    64

    Re: Applying a Macro to a range of cells

    As long as your happy, that's fine :)

    For future info, there are some add-ins available here https://www.mrexcel.com/forum/about-board/508133-attachments.html that enable you to include sample...
  7. Re: Change format of userform textbox to currency

    Maybe something like

    Me.TextBox1.Value = "123.45"
    Me.TextBox1.Value = Format(Me.TextBox1.Value, "£#,##0.00")

    change part in red to suit
  8. Re: PLACE TEXT RIGHT: place a character to the right in same place

    You're welcome & thanks for the feedback
  9. Re: Change Cell Contents if Cell Date is in Previous Month / 4 Months

    You've understood it correctly. :)
    Although as Joe4 has pointed out, I didn't factor in changing years.
  10. Replies
    9
    Views
    64

    Re: Applying a Macro to a range of cells

    Totally agree, it may also be there are only ever 2 colons, so text to columns would then work.
  11. Re: Change Cell Contents if Cell Date is in Previous Month / 4 Months

    In that case how about
    =IF(A2="","UN",IF(MONTH(TODAY())-MONTH(A2)>=2,"NC/",""))&"QUAL"
  12. Replies
    4
    Views
    56

    Re: # of labels limitation?

    I've no idea if there's a limit or not, but it will be above 35. I've seen code where people have had over 100 labels.
  13. Re: Change Cell Contents if Cell Date is in Previous Month / 4 Months

    For the first part what happens if the date is in the future?
  14. Re: Index Match with result coming from 1 of 2 Columns

    You're welcome & thanks for the feedback
  15. Replies
    9
    Views
    64

    Re: Applying a Macro to a range of cells

    It's not something I've ever used, so had to check what it was & what it did.
  16. Replies
    9
    Views
    64

    Re: Applying a Macro to a range of cells

    The problem with Text to Columns is that it will split the data on every ":" whereas the op is limiting it to 2 ":", so anything after the 2nd colon will not get split.
  17. Replies
    5
    Views
    98

    Re: Vlookup and match?

    How about
    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  18. Re: Conditional Formatting: Can I base it off of a group of other CF's?

    Fraid not.
  19. Re: Index Match with result coming from 1 of 2 Columns

    How about
    =IF(INDEX(Sheet2!Q:Q,MATCH(A1,Sheet2!B:B,0))="No", INDEX(Sheet2!D:D,MATCH(A1, Sheet2!B:B,0)), INDEX(Sheet2!R:R,MATCH(A1, Sheet2!B:B,0)))
  20. Re: VBA code to hide a range of cells based on cell value

    What is the exact value in col A?
    "Status", or "Status:" or maybe "Status: something"
  21. Re: Conditional Formatting: Can I base it off of a group of other CF's?

    CF cannot see the formatting applied to other ranges, so would have to use the various CF rules for col B on col A.
  22. Re: Help VBA Adding 4 Previous columns When Column Matches Criteria

    Glad to help & thanks for the feedback
  23. Replies
    6
    Views
    128

    Re: Dynamic ListBox for an invoice

    Glad to help & thanks for the feedback
  24. Re: ComboBox drop down list from Table not manually typed

    Glad to help & thanks for the feedback
  25. Re: Help VBA Adding 4 Previous columns When Column Matches Criteria

    Ok, how about
    Sub LNG2013()
    Dim Cl As Range
    Dim UsdRws As Long

    UsdRws = Cells.Find("*", , , , xlByRows, xlPrevious, , , False).Row
    With Range("1:1")
    .Replace "Aifinal",...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4