Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.33 seconds.

  1. Replies
    5
    Views
    24

    Re: Deselect value in inputbox

    Ok, I understand what you are saying & I know of no way to do what you are after.
  2. Re: VBA to find next empty row in worksheet isn't working!!!

    Are you looking to paste the values onto the active sheet, or a specific sheet?
  3. Re: Find last row value from multiple sheets and copy those values to another sheet

    You're welcome & thanks for the feedback
  4. Replies
    7
    Views
    47

    Re: Place sub category's letters in all items

    Glad we could help & thanks for the feedback
  5. Re: Find last row value from multiple sheets and copy those values to another sheet

    In that case you can use
    SheetList = Array("Sh1", "Sh2", "Sh3", "Sh4")
    For Count = 0 To UBound(SheetList)
    With Sheets(SheetList(Count))
    Sheets("Team_Numbers").Range("O" & Count +...
  6. Replies
    5
    Views
    24

    Re: Deselect value in inputbox

    With that code, to deselect the value, simply start typing
  7. Re: Find last row value from multiple sheets and copy those values to another sheet

    How about
    SheetList = Array("Sh1", "Sh2", "Sh3", "Sh4")
    For Count = 0 To UBound(SheetList)
    With Sheets(SheetList(Count))
    Sheets("Sh5").Range("O" & Count + 1).Value = .Range("A" &...
  8. Replies
    4
    Views
    23

    Re: INDEX MATCH two criteria with SUMIF

    Glad we could help & thanks for the feedback
  9. Replies
    7
    Views
    47

    Re: Place sub category's letters in all items

    Similar idea

    <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...
  10. Replies
    4
    Views
    23

    Re: INDEX MATCH two criteria with SUMIF

    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...
  11. Re: Run-Time error '13' Type Mismatch - only when using specific code

    Yes, just replace this
    If (PropertyTypeCB.Value) = "Single Unit" Or"Ex-Pat" Or "Holiday Let / AST" Then


    HolidayRentLa.Visible = False


    HolidayRentTB.Visible = False
  12. Re: Run-Time error '13' Type Mismatch - only when using specific code

    How about
    Select Case PropertyTypeCB.Value
    Case "Single Unit", "Ex-Pat", "Holiday Let / AST"
    HolidayRentLa.Visible = False
    HolidayRentTB.Visible = False
    Case Else
    ...
  13. Replies
    5
    Views
    24

    Re: Deselect value in inputbox

    Can you post the code that you are using to show the input box?
  14. Thread: If Lookup?

    by Fluff
    Replies
    2
    Views
    41

    Re: If Lookup?

    What are the values in col C? Are they dates formatted to show the month, or are they text values?
    If text values is it just the 1st three letters of the month?
  15. Replies
    6
    Views
    62

    Re: Conditional formatting question

    What are the rules?
  16. Re: VBA for Advanced filter copy to another location

    You may do better using a change event.
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Target.Address(0, 0) = "C4" Then
    ...
  17. Re: VBA for Advanced filter copy to another location

    How about
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Range("A5:D21").AdvancedFilter xlFilterCopy, Range("C3:C4"), Sheets("Lookup").Range("A6:D6"), False
    End Sub
  18. Re: In the formula get cell value as a row number

    You're welcome & thanks for the feedback
  19. Re: Copying cells from one sheet based on another sheet

    If you want a formula, how about
    =INDEX(Sheet2!$X$2:$X$10,MATCH(A2,Sheet2!$A$2:$A$10,0))
  20. Re: Runtime error 91 Object Variable or with block variable not set

    Excel remembers your settings for Find, so if you are searching for text, it may be doing a case sensitive search when it should be case insensitive
  21. Replies
    6
    Views
    62

    Re: Conditional formatting question

    If you select A1:D2 then apply the rules & lock the row number in the formula, it should highlight both rows.
  22. Re: In the formula get cell value as a row number

    Maybe
    =IF(MAX((FD6=INDIRECT("FD$6:FD$"&B3))*(ROW(INDIRECT("FD$6:FD$"&B3))))=0,,MAX((FD6=INDIRECT("FD$6:FD$"&B3))*(ROW(INDIRECT("FD$6:FD$"&B3)))))
  23. Replies
    8
    Views
    129

    Re: Breaking split at not 0

    Glad you sorted it & thanks for the feedback
  24. Replies
    4
    Views
    68

    Re: User Forms and Global Variable

    Glad we could help & thanks for the feedback
  25. Re: Return multiple values in one cell from VLOOKUP

    You're welcome & thanks for the feedback
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4