Jun 29, 2007 #1 fiel Programmer Jun 3, 2007 96 US I'm trying to do an if statement as follows: If (Cells(r, c) > 20) & (Cells(r, c) < 25) then I'm trying to check for a cell between two values but am not sure on how to do this boolean statement with the '&' sign. Any ideas?
I'm trying to do an if statement as follows: If (Cells(r, c) > 20) & (Cells(r, c) < 25) then I'm trying to check for a cell between two values but am not sure on how to do this boolean statement with the '&' sign. Any ideas?
Jun 29, 2007 #2 AnotherHiggins Technical User Nov 25, 2003 6,259 US for future reference, VBA/Macro-specific questions should be posted in forum707. Is this what you want: If (Cells(r, c) > 20) And (Cells(r, c) < 25) Then [tt]_____ [blue]-John[/blue][/tt] [tab][red]The plural of anecdote is not data[/red] Help us help you. Please read FAQ181-2886 before posting. Upvote 0 Downvote
for future reference, VBA/Macro-specific questions should be posted in forum707. Is this what you want: If (Cells(r, c) > 20) And (Cells(r, c) < 25) Then [tt]_____ [blue]-John[/blue][/tt] [tab][red]The plural of anecdote is not data[/red] Help us help you. Please read FAQ181-2886 before posting.