Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.57 seconds.

  1. Replies
    3
    Views
    58

    Re: convert time to fractions 1/24/ 2/24 etc

    Just change the format of the time column to ?/24
  2. Replies
    3
    Views
    98

    Re: printing all workbooks names in one shot

    Look at VBA Help for the Join function and post back if you still have questions.
  3. Replies
    3
    Views
    98

    Re: printing all workbooks names in one shot

    Sub lezawang()
    Dim asName() As String
    Dim i As Long

    ReDim asName(1 To Workbooks.Count)
    For i = 1 To Workbooks.Count
    asName(i) = Workbooks(i).Name
    Next i

    ...
  4. Thread: Simple IF

    by shg
    Replies
    13
    Views
    182

    Re: Simple IF

    =INDEX({"k3";"k4";"k5";"k6"}, MATCH(B2, {"d2";"d3";"d4";"d5"}, 0))
  5. Replies
    4
    Views
    81

    Re: User Forms and Global Variable

    Public variables need to be declared in a standard code module (not in a class module), above all procedures -- just below Option Explicit.
  6. Re: Formula to list all possible combinations of 4 rows in excel spreadsheet

    There a workbook at https://app.box.com/s/47b28f19d794b25511be with both formula- and VBA-based methods to do that.
  7. Re: Formula for Retirement Eligibility Date - min age (58) and years of service plus age is min of 70

    A correction for leaplings in the UK, Hong Kong, and other places where legal age is attained on Mar 1 in non-leap years:


    =MAX(DATE(YEAR(DoB) + 58, MONTH(DoB), DAY(DoB)),
    MIN(EDATE(DoB, 12 *...
  8. Re: Formula for Retirement Eligibility Date - min age (58) and years of service plus age is min of 70

    That's not what I get:


    A
    B
    C
    1
    DoB
    DoH
    DoR
  9. Re: Formula for Retirement Eligibility Date - min age (58) and years of service plus age is min of 70

    A
    B
    C
    1
    DoB
    DoH
    DoR

    2
    17 Nov 1980
  10. Replies
    1
    Views
    103

    Re: revison cloud add-in

    https://lmgtfy.com/?q=cloud.xlam
  11. Thread: Help!!!!!!!!

    by shg
    Replies
    7
    Views
    400

    Re: Help!!!!!!!!

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
  12. Replies
    6
    Views
    150

    Re: Custom RoundUp function Error

    I'd punt and use the Excel function:


    Public Function RoundtoUp(d As Double, n As Long) As Double
    RoundtoUp = WorksheetFunction.RoundUp(d, n)
    End Function
  13. Replies
    6
    Views
    150

    Re: Custom RoundUp function Error

    That formula/function rounds to specified significant diigits; did you want to round up? Sorry if I misunderstood.
  14. Replies
    6
    Views
    150

    Re: Custom RoundUp function Error

    Via formula:


    A
    B
    C
    D
    1
    Number
    Digits
  15. Re: Inputbox capture OK and Cancel without any data entered

    You're welcome.
  16. Re: Inputbox capture OK and Cancel without any data entered

    Not sure I follow, but perhaps:


    Sub x()
    Dim sInp As String

    sInp = InputBox("Enter something")

    If StrPtr(sInp) = 0 Then
    MsgBox "User pressed Cancel"
  17. Re: I need a way of undoing a macro that deletes all lines

    Worksheets("NPSS_quote_sheet").Copy After:=Worksheets(Worksheets.Count)
  18. Re: replace parentheses and dashes from list of #s

    Sub rn()
    With Range("D:E")
    .Replace " ", ""
    .Replace "(", ""
    .Replace ")", ""
    .Replace "-", ""
    End With
    End Sub
  19. Replies
    3
    Views
    917

    Re: Excel Repair Tool / Recomendation

    Again, you can do the same thing manually; export all the modules (including sheet modules and ThisWorkbook), then save as xlsx, close, reopen, import all the modules, then save as xlsm.
  20. Replies
    3
    Views
    917

    Re: Excel Repair Tool / Recomendation

    Free: http://www.appspro.com/Utilities/CodeCleaner.htm

    It automates what you could do (what I used to do) manually: Export all code, save as an xlsx file, then reinstall the code.
  21. Thread: Oh4fore

    by shg
    Replies
    4
    Views
    189

    Re: Oh4fore

    Like this, for example?


    A
    B
    C
    D
    E
    F
    G
  22. Replies
    2
    Views
    98

    Re: VBA to run a max of once a day

    The code could create a named formula contain the last run date, and not run again until that date passes.
  23. Thread: Set array formula

    by shg
    Replies
    4
    Views
    245

    Re: Set array formula

    You canít enter an array formula longer than 255 characters via VBA in a single go. At http://www.dailydoseofexcel.com/archives/2005/01/10/entering-long-array-formulas-in-vba/, **** Kusleika shows...
  24. Re: Can I Code a macro that has Saved Text descriptions based on a criteria?

    If you were using formulas, it would be a simple VLOOKUP, no?

    So put a lookup table on a (perhaps hidden) sheet and use that in your code.
  25. Replies
    10
    Views
    294

    Re: I need with my friend

    Format E2 as General.

    The formula in C2 should be =DATEDIF(B2, A2, "y")
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4