Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.30 seconds.

  1. Re: Pop Up when I convert Excel workbook from 2000 to 2016

    What happens if you use "Save As"
  2. Re: problem with exiting loop after 'If Then Else' procedure is executed...

    You're welcome & thanks for the feedback
  3. Replies
    16
    Views
    134

    Re: formula from a date in a different cell

    You're welcome & thanks for the feedback
  4. Replies
    1
    Views
    35

    Re: Copy Select Cells in For Each loop - VBA

    Rather than looping through the cells, youl'd be better using an autofilter
    Sub LateStatusReport()

    Dim lastRow As Double
    Dim rowValue As Integer
    Dim txt As Range
    Dim shname As String
    Dim...
  5. Re: problem with exiting loop after 'If Then Else' procedure is executed...

    If you want to exit the loop, replace Exit Sub with Exit For
  6. Replies
    9
    Views
    56

    Re: For Each Loop and Functions

    You're welcome & thanks for the feedback
  7. Replies
    9
    Views
    56

    Re: For Each Loop and Functions

    What was the error message & number
  8. Re: what is wrong with this single line of code (finding last row in a column)

    You're welcome & thanks for the feedback
  9. Re: Force Userform textbox to text only format

    How about
    TypeHrRNG.NumberFormat = "@"
    TypeHrRNG = txtHOURS.Value
  10. Replies
    2
    Views
    37

    Re: Need help to learn vlookup formulation

    Hi & welcome to MrExcel
    Have a look here https://exceljet.net/excel-functions/excel-vlookup-function
  11. Re: what is wrong with this single line of code (finding last row in a column)

    Like
    Range("F1").End(xlDown).Offset(1).Row

    But if you have any blank cells in col F you might get the wrong result
  12. Re: VBA to Hide Tabs based on Cell contents located in a "Log" tab

    You're welcome & thanks for the feedback
  13. Replies
    9
    Views
    56

    Re: For Each Loop and Functions

    Or, using the way you were trying
    Private Sub PoleStrength_Click()
    Dim rng As Range, cell As Range
    Set rng = Sheet2.Range("R17:R43")

    For Each cell In rng
    If...
  14. Replies
    9
    Views
    56

    Re: For Each Loop and Functions

    How about
    Sub PaulAsaran()
    Range("R17:R43").Formula = "=IF(NOT(Data!A2),Data!N2,0)"
    End Sub
  15. Re: Compare two columns of two sheets and insert row if new data found

    If it is just the 1st 2 columns, try

    Sub Itzybell()
    Dim Ary As Variant
    Dim i As Long, j As Long

    Ary = Sheets("Sheet2").Range("A1").CurrentRegion.Value2
    With Sheets("Sheet1")
    ...
  16. Replies
    9
    Views
    56

    Re: For Each Loop and Functions

    How about putting the formula back in those cells, would that work?
  17. Re: what is wrong with this single line of code (finding last row in a column)

    It Returns 1, because you are only searching one cell (namely F1)
  18. Re: Remove last value in each column (different sizes)

    You're welcome & thanks for the feedback
  19. Re: VBA to Hide Tabs based on Cell contents located in a "Log" tab

    How about
    Sub Evremonde()
    Dim Cl As Range

    With Sheets("Log")
    For Each Cl In .Range("A3", .Range("A" & Rows.Count).End(xlUp))
    If Cl.Value <> "" Then
    If...
  20. Re: Trying to set two variables as one variable.

    You cannot use variables in that way.
    However you could use an Array to store values you want
  21. Re: Compare two columns of two sheets and insert row if new data found

    Do you just want to copy over cols A & B, or are there other columns that need to be copied?
  22. Thread: Holiday Calendar

    by Fluff
    Replies
    10
    Views
    138

    Re: Holiday Calendar

    If you just want to highlight the cell, select B3:AF4 and use this formula
    =SUMPRODUCT(('Holiday 2019-2020'!$C$4:$C$15=$A3)*('Holiday 2019-2020'!$A$4:$A$15<=B$2)*('Holiday ...
  23. Replies
    3
    Views
    108

    Re: If Not Open, Open File - VBA

    That's ok.
  24. Replies
    2
    Views
    51

    Re: Count IFs Formula With Dates

    Not sure it's much easier, but you could use
    =COUNTIF(INDEX($B$2:$K$4,0,MATCH($B$6,$B$1:$L$1,0)),A7)
    Changing the value in red for each section
  25. Re: Compare two columns of two sheets and insert row if new data found

    Simplest way is to sort sheet1 after updating it.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4