Hello.
In Sheet2 (Named Shift_One) I have a Public Sub named verifyCells()
It has a lot of calls to a function in the same sheet that are formatted this way:
cellNotEmpty Range("B1")
cellNotEmpty Range("B3")
This is my public function:
Public Function cellNotEmpty(rngT As Range)
If IsEmpty(rngT) Then
MsgBox (rngT.Address & " Cannot Be Blank")
End If
End Function
In Sheet3 (Named Shift_Two) I have the following code:
Sub SaveShiftTwoReport()
Worksheets("Shift_Two").Select
Sheet2.verifyCells
Is it possible to call the verifyCells function on Sheet2 and run cellNotEmpty Range("B1") from Sheet3 but have it check Sheet3's cells for blanks instead of running it on sheet2?
Bookmarks