Using VBA in Excel, how do I clear 1 row of data (columns A - J) without deleting the actual row (as I have formatted blank rows that follow and need to keep)? Cell in Column D needs to be selected.
Posted on 2013-02-05
Also note that as this "row" of data is erased/cleared/deleted, all data rows below it need to move up to keep all the records contiguous.
Range("E" & ActiveCell.Row, Selection.End(xlToRight)).Select
Range("C" & ActiveCell.Row, Selection.End(xlToLeft)).Select