This code does exactly what I need it to do but not across a range of cells

Private Sub Worksheet_Calculate()
If Range(“D3”).Value <> PrevVal Then
Call TimeCopy
Call DriverSort
PrevVal = Range(“D3”).Value
End If
End Sub

If I could get this code to call my macros if there was a change in any of the cells in this range (B3:B50) my problems would be solved.

Contributor Asked 4 hours ago in VBA: Macros.
Add Comment
0 Answer(s)
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.