Posts by blue3zero

    Re: Find First Non-empty Cell & Paste To Preceding Cells


    I added the following to the macro and it seems to have done the trick.
    Does anyone see any danger to this method?



    Code
    Columns("K:K").Select
        Selection.SpecialCells(xlCellTypeBlanks).Select
        Selection.Replace What:="", Replacement:="XXCXX", LookAt:=xlPart, _
            SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False

    Re: Find First Non-empty Cell & Paste To Preceding Cells


    I have a sheet that is always layed out the same. Columns A through K with x amount of rows.


    I have a macro that I recorded and modified a little that does a few things to format the sheet correctly and autofills columns A and C.
    I need to find all of the blank cells in column K and fill it in with the value 'XXCXX'.


    Here is the code of the macro that I have so far