Hi i have an excel workbook whereby when any cell in any worksheet is changed then it executes a module which works really well. The problem is it is really slow so i am looking at restricting the execution of this module so that it only executes when specific cells are changed. Can this be done?
I currently have the following
Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Source As Range)
' runs when a sheet is changed
Sheetchanges.ChangeSheets
End Sub
And my module is called "sheetchanges" which has all of the macros in.
Do i need something like this in there somehwere?
If Intersect(Target, Range("A1,B1")) Is Nothing Then Exit Sub
I'm a bit of a newby with marcos to be honest and i got help writing the above macro.
Any help would be much appreciated
Thanks
Bookmarks