using a cells postion/range in an if then statment

All,

I am trying to get an "if, then..." statement condition to be based on the position/range of a cell. Specifically I want my code to do exactly the flowing:

if active cell is in column u (21) or greater (after) then
do something

what would be the best way to acheive this?


I have been trying to use ActiveCell.Range and Range.Range with IS TRUE; the syntax I am using did not flag in red as a "syntax error", i.e.:

Please Login or Register  to view this content.

(column 30, AD is passed the end of the data columns, so it is just an end point to make the statement, effectually a greater than)

but when I try to run the code it gives me this error: compile error: type mismatch. What would be the method/syntax to use?

I have no way of predicting the values that will be in any cell or even if the cell is going to be null.

excel version: 14.0.7232.5 32 bit
operating system: windows 7 professional

Thanks in advance
Lconner_2