In a previous question, expert Rgonzo1971 assisted me in writing a VBA function (see below).
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
If Not Intersect(Target, Range("A1")) Is Nothing Then
Range("A2:A" & Rows.Count).RowHeight = 15
If Target <> "" Then
aRows = Split(Target, ",")
For Each rw In aRows
Application.ScreenUpdating = True
While the VBA works great, it appears it "slows down" performance on the spreadsheet. That is, any change on the XLS results in running the VBA.
Instead, I need to run the VBA only when a single cell (i.e., B1) is changed. How can the code be rewritten so that only a change in cell B1 calls the VBA... but not any other change in the spreadsheet?