• Ask a Question
150
Insert Image Size must be less than < 5MB.
    Ask a Question
    Cancel
    150
    More answer You can create 5 answer(s).
      Ask a Poll
      Cancel
      Top Contributor

      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.

      Asked by Daisy509th on October 27, 2017 in VBA: Macros.
      1 Answers
      Top Contributor

      Sub sbDriverCopy()
      ActiveSheet.Range(“D3:H53”).Copy
      ActiveSheet.Range(“J3”).Select
      ActiveSheet.PasteSpecial xlPasteValuesAndNumberFormats
      Application.CutCopyMode = False
      End Sub
      Sub sbDriverRotation()

       

      Answered by Daisy509th on October 31, 2017..