Selecting a column , row or cell

[nghica]

I want to select a column, a row or a cell, but the trick is that the cell i
want to select depends on the value of another cell. for example if A1=7 and
A2=5, i want to select the cell with row 5 and column 7, cell G5 is that
possible with a command in VBA?

something like: Range("Value(A1),Value(A2)").Select

Is that even possible with a command in VBA?

or is there any posibility to select a column row or range not by their
coordonates but depending on the current date or depending on the position of
other culumns or cells?


Thank you very much for your help

 

[Sam Wilson]

eg:

Cells(Range("A1").value,range("A2").value).Select

etc

 

[Patrick Molloy]

WITH cells(range("row").Value, Range("Col").Value )
..interior.color = vbRed
END WITH