If Then Else... selected text in a cell, help!

[[email protected]]

Here's my code, obviously I'm using the wrong thing in the If, but I think you should be able to understand what I want:

Sub billable_time()

If Range("B2").Select = "none" And Range("B3").Select = "BNC" And Range("B4").Select = "Flat Fee" And Range("B5").Select = "Hourly" Then

//my macro code...

//possible to do an elseif? I tried..

else

If Range("B2").Select = "none" And Range("B3").Select = "Flat Fee" And Range("B4").Select = "Hourly" Then

//my other macro code...

else

end if
end if

end sub


Thanks to anyone who can help!

[jasoncw]

Remove all .Select notations:

Please Login or Register  to view this content.

[[email protected]]

haha, easier than I thought. Thanks a lot!

[jasoncw]

No problem.