greeting to all of you
i'm new to macro, and i found below code which can record any changes in excel and that's just prefect for my workbook
however i have almost 20 macros to run, so i'm wondering is there any possible way to record after that?
stay safe everyone
thanks again
i'm new to macro, and i found below code which can record any changes in excel and that's just prefect for my workbook
however i have almost 20 macros to run, so i'm wondering is there any possible way to record after that?
VBA Code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim LR As Long
Dim c As Range
Application.EnableEvents = False
With Sheets("LogSheet")
For Each c In Target
LR = .Cells(Rows.count, "A").End(xlUp).Row + 1
.Cells(LR, "A").Value = Sh.Name & "!" & c.Address
.Cells(LR, "B").Value = Now
.Cells(LR, "C").Value = c.Value
Next c
End With
Application.EnableEvents = True
End Sub
stay safe everyone
thanks again