Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.33 seconds.

  1. Replies
    3
    Views
    28

    Re: Divide but keep minimum value

    You're welcome & thanks for the feedback.
  2. Replies
    3
    Views
    28

    Re: Divide but keep minimum value

    Something like
    =max(1,yourformula)
  3. Re: VBA check for negative numbers in column and add text in corresponding cell in a different column

    That would suggest that you have error values in col Z like #N/A, #VALUE! etc
  4. Replies
    20
    Views
    302

    Re: Dynamic Ranges for Filter Macros

    In that file everything is numeric, will that be the case for your real data?
    Also will you have just 1 value to filter on?
  5. Re: VBA check for negative numbers in column and add text in corresponding cell in a different column

    Also didn't notice you want to put the text in col I so this
    cell.Offset(0, 17).Value = "Applied payment"should be
    cell.Offset(0, -15).Value = "Applied payment"
  6. Re: VBA check for negative numbers in column and add text in corresponding cell in a different column

    What is the error number & message?
  7. Re: Struggling to Use Small(IF...)) formula to return multiple results

    Without being able to see your data, it's difficult to tell, but try this non array formula

    =IFERROR(INDEX('Alberta Planning Sheet Falcon'!$A$2:$A$29,AGGREGATE(15,6,(ROW('Alberta Planning Sheet...
  8. Re: VBA check for negative numbers in column and add text in corresponding cell in a different column

    It's the line above that causes the problem, try
    Dim rng As Range
    Set rng = Range("Z1", Range("Z" & Rows.Count).End(xlUp))
    For Each cell In rng
    If cell.Value < 0 Then
    cell.Offset(0,...
  9. Re: Struggling to Use Small(IF...)) formula to return multiple results

    Glad you sorted it out & thanks for the feedback.
  10. Replies
    20
    Views
    302

    Re: Dynamic Ranges for Filter Macros

    ThisWorkbook refers to the workbook that contains the macro, so in this case that's the personal.xlsb, so you need to use
    Sub steveh8204()
    Dim Ary1 As Variant, Ary2 As Variant

    With...
  11. Re: Excel related, but not formulas or visual basic

    You're not by any chance hitting Alt+W+H are you?
  12. Replies
    20
    Views
    302

    Re: Dynamic Ranges for Filter Macros

    My pleasure & thanks for the feedback
  13. Re: Look for B1 value in another workbook, then see if somewhere in that row the value matches A2

    How about
    =IF(ISNUMBER(MATCH(AB$1,INDEX(Sheet1!$E$2:$Z$9,MATCH($A2,Sheet1!$C$2:$C$9,0),0),0)),"x","")
  14. Re: Find And Replace in Multi excel files with multi worksheets

    That works for me.
    Try stepping through the code using F8 and when you get to the line that doing the replacing, hover the cursor over strFind & strReplace to check that they still fold the correct...
  15. Replies
    20
    Views
    302

    Re: Dynamic Ranges for Filter Macros

    I got you.
    On the View tab select Unhide, then select Personal.xlsb & OK
    You can then use the file like any normal file, but you may want to hide it again, otherwise will it always be visible.
  16. Replies
    20
    Views
    302

    Re: Dynamic Ranges for Filter Macros

    You can store the list in your personal.xlsb file, just change the sheet name in red to suit
    With ThisWorkbook.Sheets("List")
  17. Replies
    20
    Views
    302

    Re: Dynamic Ranges for Filter Macros

    If the code is in your Personal.xlsb file try
    Sub steveh8204()
    Dim Ary1 As Variant, Ary2 As Variant

    With ThisWorkbook.Sheets("List")
    Ary1 = .Range("A1", .Range("A" &...
  18. Re: Count number of times a specific text appears in a string & range

    Glad we could help & thanks for the feedback
  19. Re: Excel VBA: How to compare values of two cells?

    You're welcome & thanks for the feedback
  20. Re: Count number of times a specific text appears in a string & range

    Judging by post#4
    Maybe

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  21. Replies
    20
    Views
    302

    Re: Dynamic Ranges for Filter Macros

    Do you have the code in your Personal.xlsb file?
  22. Re: Find And Replace in Multi excel files with multi worksheets

    And what is the complete formula that you are trying to change?
  23. Re: VBA Move Data to different Worksheet if specific cell not empty

    You do not need to close the posts on the other sites.
    Just remember to supply links, if you do this in the future.
  24. Re: Excel VBA: How to compare values of two cells?

    Ok, how about
    Sub SortAndMergeDupes()

    Dim i As Long
    Dim Cl As Range, Rng As Range
    Application.ScreenUpdating = False
    With Sheets("Pcode")
    For i = .Range("B" &...
  25. Re: [vba] Checking if sheet exists inside array

    You're welcome & thanks for the feedback.

    If you try
    If SheetExists(CStr(sheetname)) ThenThat should sort the problem.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4