Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Re: Code to change date to 1 years time by using a pro-word

    @MickG 's is more elegant. Here's another approach.



    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Targ As Range, cel As Range, dt As Date
    Dim i&


    Set Targ =...
  2. Re: Finding Shortest Time Span within a Time Range.

    You could use a UDF that splits the string into time ranges and compares the differences in minutes.


    Function MinTime(str As String) As Long
    Dim aTimes As Variant
    Dim arr As Variant
    Dim v As...
  3. Replies
    2
    Views
    181

    Re: Aged Dates Categorize

    Excel 2010
    <colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>

    C
    D

    </thead><tbody>
    1
    Fixed Date
    6/7/2019
  4. Replies
    3
    Views
    334

    Re: Date Formatter Macro

    Here's a sub that would look at each "word" in a selection, checking for a date value, and convert it to the long date. You could assign the shortcut, then save the document as an add-in.



    Sub...
  5. Re: Recording positive and negative time formula

    You could change to the 1904 Date system.

    See: https://excelribbon.tips.net/T006239_Displaying_Negative_Times.html

    https://images.tips.net/S22/Figs/T6239F1.png
  6. Re: Excel form resizing according to screen resolution

    Welcome to the forum!

    I had a similar dilemma w/ a group I support. I polled the group and found 2 primary resolutions: the standard at the time was 1280 X 1024, the low-res option (to make the...
  7. Re: VBA - How to invert/sort line breaks within a cell

    For the second question: https://www.mrexcel.com/forum/excel-questions/1100113-sort-contents-within-1-cell.html
  8. Re: Additional help in extracting data from string of characters

    Good catch, Eric! I actually used one of your older posts as inspiration.
  9. Re: Additional help in extracting data from string of characters

    try:

    =TRIM(LEFT(RIGHT(SUBSTITUTE(SUBSTITUTE(A1," "," ")," ",REPT(" ",100)),200),100))
  10. Thread: For each

    by CalcSux78
    Replies
    5
    Views
    157

    Re: For each

    Dim shp As Shape

    For Each shp In Sheet3.Shapes
    shp.Visible = msoFalse
    Next shp
  11. Re: VBA - WorksheetFunction.Small with conditions??

    Excel 2010
    <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>

    A
    B
    C
    D
    E
    F
  12. Replies
    2
    Views
    195

    Re: Sort Contents Within 1 Cell

    Not sure if there's a worksheet function to do this...

    With this method, you would select a range to have sorted, then run the code.



    Sub AlphaSelection() 'select range to sort then run
    ...
  13. Replies
    3
    Views
    171

    Re: Help with Clear Contents

    Try:

    Range(Cells(i, x), Cells(i, x).Offset(0, 3)).ClearContents
  14. Re: How to not scramble punctuation symbols while scrambling words?

    I was a bit lost in your logic. I see that you take the phrase and split into individual words. From there, I would load the characters from the second character to the second to last character...
  15. Replies
    4
    Views
    186

    Re: Put Two values into Clipboard with VBA

    I ran into issues on one of our users machines with loading the clipboard. We had to approach with a late-binding method.


    Dim dObj As Object

    Set dObj =...
  16. Replies
    6
    Views
    289

    Re: VBA Arrays for concatenate?

    If you do not want duplicate countries, modify the Else statement in Fluff's code to this:


    ElseIf InStr(1, .Item(Cl.Offset(, -1).Value), Cl.Value, vbTextCompare) = 0 Then
    .Item(Cl.Offset(,...
  17. Replies
    3
    Views
    247

    Re: convert currency from numbers to words

    try: http://quadexcel.com/how-to-convert-numbers-to-words-in-indian-currency-format-vba-macros/
  18. Replies
    3
    Views
    256

    Re: End Time - Start

    Not sure if I follow you on the last part. Would you be able to post your conditional formatting formula?

    Also, to clarify... You do want to round the start time and the end time, then take the...
  19. Replies
    5
    Views
    476

    Re: Little Nudge needed to get me home free

    Sorry, I didn't test fully since I don't have an "L drive".

    ExportAsFixedFormat is a method of Word.Document (objDoc), not Word.Application (objWord). So adjust your last line to this:
    ...
  20. Replies
    5
    Views
    476

    Re: Little Nudge needed to get me home free

    What's Up Chuck (sorry for the dad joke)

    Try:


    Sub Test()
    Dim Pth As String, Fname As String
    Pth = "C:\Latex Free Holder" & "\"
    Fname = "Cover Letter"
  21. Replies
    3
    Views
    256

    Re: End Time - Start

    MROUND should get you there:

    Excel 2010
    <colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>

    A
    B
    C

    </thead><tbody>
  22. Replies
    2
    Views
    348

    Re: macro to copy vba macro

    Chip Pearson (R.I.P.) has a page on copying code to a text file: http://www.cpearson.com/Excel/vbe.aspx (Scroll half way down or do a search for "Code Module To A Text File")

    Please read through...
  23. Re: Time taken between jobs (start time and finish time)

    Simple subtraction should work, but you'll need some custom number formatting.

    Your example, when subtracted should yield 0.019965.

    When you change the number format to a custom: [h]:mm:ss
  24. Re: entering a vlookup formula into a cell using vba

    Try:

    Range("C4").Formula = "=VLOOKUP($B4," & R & ",2,FALSE)"
  25. Re: How to include Background Query Completing time in timing my macro

    When you use RefreshAll, tje code refreshes everything, but continues the code before completing the refresh. If you want to see how long it takes to refresh each one, you could use a loop to time...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4