I have an extensive Worksheet_Change subroutine that works perfectly on Sheet6 where it is located. The routine is written so that everything accesses "activesheet" rather than the sheet name. I have parallel structures on Sheet3 and Sheet9 but they are not accessing the subroutine. I tried this:
Private Sub Worksheet_Change(ByVal Target As Range)
Sheet6.Worksheet_Change (Target)
End Sub
And get an undefined object error. Can someone explain the rules for accessing subroutines and functions in another sheet.
Thanks so Much
Michael
Private Sub Worksheet_Change(ByVal Target As Range)
Sheet6.Worksheet_Change (Target)
End Sub
And get an undefined object error. Can someone explain the rules for accessing subroutines and functions in another sheet.
Thanks so Much
Michael