Hello,
I am trying to use the Worksheet_SelectionChange event for the first time instead of using the Worksheet_Change event in the hopes that it will only run the macros when specific cells are changed. This is because when it runs, there is a very long lag time, which holds up the ability to use the spreadsheet if the change event is used. So, since the macros are only needed rarely when specific cells are changed, I was hoping the selection change event would work.
Below is part of the code I came up with. I need the code to run when there are changes to cells R4, P1, P2, A10, and A14. The code is actually much longer with many more like A10 and A14, but I omitted them for this example.
I tried just using two of the targets in the example I found online, If Target.Address = "$R$4" Or Target.Address = "$P$1" Then MsgBox "Success".But it isn't working, so I obviously included it wrong.
Bookmarks