Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Thread: IF formula

    by footoo
    Replies
    3
    Views
    121

    Re: Need some help with what I thought was a basic IF formula

    =if(az2<$ax$7,"",ba2/az2*100)
  2. Re: Macro execution via the RIBBON has stopped.

    Try re-assigning the macro to the button.
  3. Replies
    3
    Views
    66

    Re: identify distinct names in filtered list

    https://www.google.com/search?q=excel+countif+visible+rows+only&rlz=1C1CHZL_enHK747HK747&oq=excel+countif+visible&aqs=chrome.2.69i57j0l5.29711j0j8&sourceid=chrome&ie=UTF-8
  4. Replies
    2
    Views
    138

    Re: VBA - auto login to website

    Sub FUNC_LOGIN_KRONOS()
    Dim appIE As Object: Set appIE = CreateObject("InternetExplorer.Application")
    With appIE
    .navigate "https://kronos-emea.dhl.com/wfc/logon/"
    Do While .Busy Or...
  5. Re: Excel 2016, formatting a cell with just a year

    Put in the first cell and fill down:

    =TEXT(TODAY(),"yyyy")+ROW(A1)-1
  6. Replies
    13
    Views
    386

    Re: proper syntax for With Rng/Evaluate?

    Doesn't post #5 do what you want?
  7. Replies
    13
    Views
    386

    Re: proper syntax for With Rng/Evaluate?

    Dim f$: f = "36, "
    Dim rng As Range: Set rng = [A1:A8]
    rng = Application.Evaluate("concatenate(" & f & """, ""," & rng.Address & ")")
  8. Re: Save to new worksheet and rename sheet to tomorrows/next working days date as ddmmyyyy

    https://www.mrexcel.com/forum/excel-questions/1029649-vba-code-next-business-day.html
  9. Replies
    1
    Views
    81

    Re: Holiday/annual leave tracker

    Maybe use a Time Sheet template.
  10. Re: VBA Code - Obtain variable row numbers; use in formula

    https://www.mrexcel.com/forum/excel-questions/1108887-hopefully-easy-sum-macro.html
  11. Thread: Percentage

    by footoo
    Replies
    4
    Views
    101

    Re: Percentage

    One way to get the correct quotation marks is via the macro recorder.
  12. Thread: Percentage

    by footoo
    Replies
    4
    Views
    101

    Re: Percentage

    Range("D2:D" & lr).Formula = "=C2/sum(C$2:C" & lr & ")"
  13. Re: Find next empty row and select Columns A to D

    If you mean the row after the last row with data :
  14. Re: Searching for information and then returning that info.

    Or :

    =IFERROR(MID(B2,SEARCH(10000,B2),10),"")
  15. Re: Searching for information and then returning that info.

    =if(mid(b2,2,5)="10000",mid(b2,2,10),"")
  16. Re: VBA Update new cell with values and format

    First get the code from the macro recorder and tweak it to avoid sheet switching.
    If you don't know how to tweak it, post the code and someone will do it for you.
  17. Re: VBA Update new cell with values and format

    Copy/PasteSpecial/Format.
    The code can be obtained from the macro recorder.
  18. Thread: football table

    by footoo
    Replies
    2
    Views
    122

    Re: football table

    There are plenty of free Excel football table templates available on the internet. Have you done a search?
  19. Replies
    16
    Views
    608

    Re: Scramble a string with conditions

    Sub Set_String()
    Dim com$, ray As Variant, i%, comb$
    Dim str$: str = "ABBA"
    com = Get_Comb("", "", str)
    ray = Remove_Dup(Split(com, ","))
    For i = 1 To UBound(ray) - 1
    comb = comb & " " & i...
  20. Re: Macro to change text in macro on control button in workbook?

    It could be done with a macro that loops each of the 700 files, deletes the old macro and inserts the new macro.
    Whoever creates the macro will need to know:
    - the location of the 700 files
    - the...
  21. Re: Macro to change text in macro on control button in workbook?

    If the tab names have not been changed in the 700 files, why do you need to change the macros in those files?
  22. Replies
    6
    Views
    107

    Re: Formula to show first sheet name

    As explained in the link, create a named range called "sheetnames" with this in the RefersTo box: =GET.WORKBOOK(1)&T(NOW())

    (Also, see the link within the link:...
  23. Re: Macro to change text in macro on control button in workbook?

    If the sheet codename is the same for all files, just change your macro to refer to the codename instead of the sheet tab name.
  24. Replies
    6
    Views
    107

    Re: Formula to show first sheet name

    It doesn't involve any VBA. Just follow the instructions in the link.
  25. Replies
    6
    Views
    107

    Re: Formula to show first sheet name

    https://exceljet.net/formula/list-sheet-names-with-formula
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4