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 |
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 |
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 |
All times are GMT +1. The time now is 11:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com