B
Brad
Thanks for taking the time to read my question.
I'm passing a string that is a cell reference to a function. In that
function I want to determine if that cell reference is within a predetermined
range. Not sure how to do that. Right now I have:
Function CheckRange(TheSheet As String, TheCell As Range) As Boolean
If TheSheet = "Sheet1" Then
if TheCell In Range("B4:B30") then 'This line is red as it is incorrect
CheckRange = True
End If
What do I use instead of "In"?
Thanks,
Brad
I'm passing a string that is a cell reference to a function. In that
function I want to determine if that cell reference is within a predetermined
range. Not sure how to do that. Right now I have:
Function CheckRange(TheSheet As String, TheCell As Range) As Boolean
If TheSheet = "Sheet1" Then
if TheCell In Range("B4:B30") then 'This line is red as it is incorrect
CheckRange = True
End If
What do I use instead of "In"?
Thanks,
Brad