rangea1az

  1. H

    Macro to clear data

    I have the folowing macro The data is only cleared on sheet "Imported Data" and not on sheet "All Data" Kindly amend my code Sub Clear_Data() Sheets("Imported Data").Select Dim LR As Long LR = Cells(Rows.Count, "A").End(xlUp).Row With Range("A1:AZ" & LR) .UnMerge End With With...

Some videos you may like

This Week's Hot Topics

Top