I am a new to VBA (fun!) and am trying to write code that determines if the top cell (on row 5) of the active column contains a specific string. e.g. "Sun". I understand how to use the intstr, but cannot figure out how to change the range/cell reference in the bracket to reflect a different column. Thanks for any advice at all!!!
If InStr(1, [b5], "Sun", vbTextCompare) > 0 Then
MsgBox "It is Sunday."
MsgBox "It is not Sunday"