Posts by NoSparks

    Re: New sheet date update


    See if this macro does what you're after

    Re: Saving a file to same file name


    If I follow what you're wanting, and I'm not sure I do,
    maybe adding a sub to a standard module

    Code
    Public Sub Save_Right_Away()
        ThisWorkbook.Save
    End Sub


    and adding an instruction to the Workbook_Open sub that will run that sub 3 seconds after the workbook opens ?


    Code
    Application.OnTime Now + TimeValue("00:00:03"), "Save_Right_Away"

    Re: Insert missing time in between rows


    After removing the stray items down around row 4500...
    try this on your test file

    Re: want to use single button to goto multiple cell (excel)


    Perhaps you could use a macro along the lines of this assigned to the button

    Code
    Option Explicit
    Dim nextClick As Long
    
    
    Sub WhereToGo()
      If nextClick = 0 Or nextClick > 3 Then nextClick = 1
      Range("D" & Choose(nextClick, 43, 59, 60)).Select
      nextClick = nextClick + 1
    End Sub

    Re: Count column if NOT a duplicate (Excel 2010)


    The array formula the OP shows is for the question as asked.
    It's not what the OP wants because of what defines a duplicate.
    Duplication is determined by more than just this range and what is determined to be a duplicate is color filled orange, color index 44, via VBA not conditional formatting.


    The question should have been:
    Is there a formula that will count the non-blank cells in a range that are any color other than orange?

    Re: Run-time error '1004'


    Quote

    ii. If it is "unprotected" the items at columns "BA:BE" will automatically moved to " column AY".


    The sheet protection doesn't have anything to do with that, it just stops the macro from running.
    Unprotect the sheet and add this

    Code
    .CurrentRegion.Select
                MsgBox Selection.Address
                Exit Sub


    between these two lines and see where you're actually asking for things to happen (comment them out later.)

    Code
    With .Offset(1, .Columns.Count + 1).Resize(1, 5)
                
                .CurrentRegion.Clear

    Re: Need help modifying existing macro to auto count cells


    Based on your existing code, I'd do it like this

    Re: VBA Copy Paste Copy Loop


    Try this

    Re: Find and Replace Carriage Returns to carry out text to column


    Try this little piece of code to see what characters you are really dealing with.