This should be an easy one to solve.
In my VB macro code, I want to make a check on a cell's entry, but my mind just isn't working tonight.
If Cell B4 = 1, then I want my VB code to check this.
So I want my code to do this:
If B4 = 1 Then
some code
some code
some code
End If
But what do I put after the 'If' statement to make the check? I know that the code above doesn't work, but do I have to put something like:
"If ActiveWorkbook.B4=1 Then..."
Or something similar?
Basically, what do I have to put in the If statement for the code to check the contents of cell B4???
Thanks.
Bookmarks