Hi
I tried to record a macro for deleting all the data from the sheet except the first row but it does it for a few initial columns and 3 to 4 columns remain just as they are.
So, I want to modify that macro so all the data except the first column gets deleted.
The macro is written as:
Sub Clear_Data()
'
' Clear_Data Macro()
'
'
Range("A2").Select
Range(Selection, Selection.End(x1Down)). Select
Range(Selection, Selection.End(x1Down)). Select
Range(Selection, Selection.End(x1ToRight)). Select
Range(Selection, Selection.End(x1ToRight)). Select
Range(Selection, Selection.End(x1 ToRight), Select
Range(Selection, Selection.End(x1 ToRight)), Select
Range(Selection, Selection.End(x1 ToRight), Select
Range(Selection, Selection.End(x1 ToRight), Select
Selection.ClearContents
End Sub
Please advise.
Regards
Bookmarks