Excel Macro Help to delete first cell
Closed
Karthik
-
23 Sep 2010 à 17:31
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 23 Sep 2010 à 23:28
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 23 Sep 2010 à 23:28
Related:
- Excel Macro Help to delete first cell
- Excel online macros - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Delete duplicates in excel - Guide
- How to delete cell in word - Guide
- Excel run macro on open - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
23 Sep 2010 à 23:28
23 Sep 2010 à 23:28
Karthik
you need an event code which is a macro but which will be automatically activated if an event occurs.
BEFORE DOING THIS AS YOU ARE MESSING UP WITH DATA KEEP THE ORIGINAL DATA SAFELY SOMEWHERE
right click the sheet tab and click view code. in the window that comes up copy this event code. do this on an experimental sheet firt.
you need an event code which is a macro but which will be automatically activated if an event occurs.
BEFORE DOING THIS AS YOU ARE MESSING UP WITH DATA KEEP THE ORIGINAL DATA SAFELY SOMEWHERE
right click the sheet tab and click view code. in the window that comes up copy this event code. do this on an experimental sheet firt.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range, c As Range
If Target.Address <> "$C$11" Then Exit Sub
Set r = Range("c1:c10")
For Each c In r
c = c.Offset(1, 0)
Next c
End Sub
