Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a column , row or cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a column , row or cell
eg:
Cells(Range("A1").value,range("A2").value).Select etc "nghica" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a column , row or cell
WITH cells(range("row").Value, Range("Col").Value ) ..interior.color = vbRed END WITH "nghica" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting the first blank cell in a column | Excel Programming | |||
Selecting A Column based on Cell Value | Excel Discussion (Misc queries) | |||
Selecting the cell in Column A | Excel Programming | |||
selecting column down to variant cell | Excel Programming | |||
Selecting single column with merged cell at top | Excel Programming |