Selecting a column , row or cell

  • Thread starter Thread starter nghica
  • Start date Start date
N

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
 
WITH cells(range("row").Value, Range("Col").Value )
..interior.color = vbRed
END WITH
 
Back
Top