Hi All:
Below is the beginning portion of my code and I want to alter it to say:
IF cell "B5" of the "Input Sheet" equals 7 or 27 or 37 then continue with the code otherwise EXIT SUB.
I ahve played around a bit but can't get it to function... THANKS.
How do I change this line to reflect my wishes??? THANKS.
Take Care,
Mark
Below is the beginning portion of my code and I want to alter it to say:
IF cell "B5" of the "Input Sheet" equals 7 or 27 or 37 then continue with the code otherwise EXIT SUB.
I ahve played around a bit but can't get it to function... THANKS.
Code:
Sub MiscReconSort()
''''''''''''''''''''''''''''
Sheets("MiscRecon").Select
Range("A5").Select
If Sheets("Input Sheet").Range("B5").Value = "7","14","37" Then
If Sheets("MiscRecon").Range("C256").Value = 0 Then Exit Sub
ActiveSheet.Unprotect "unlock"
How do I change this line to reflect my wishes??? THANKS.
Code:
If Sheets("Input Sheet").Range("B5").Value = "7","14","37" Then
Take Care,
Mark