Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a Column with a Variable name
I have a variable (Columnname) that finds a column where a Cell in a
row equals a value on another page.(A user inserts a date on the first page and it matches a value in a row on another page and this variable is set to that column) The problem I am having now is using it to set other cells. Normally to set a cell on this page I would use worksheetname.Range("B4").Value = something But since the column is not going to be equal to "B" every time I need to be able to call that variable Columnname so something like worksheetname.Range.("Columnname" + 3).value = somthing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable cell referencing | Excel Worksheet Functions | |||
Referencing tab based on Variable | Excel Worksheet Functions | |||
Help with referencing variable range | Excel Programming | |||
referencing worksheet as a variable | Excel Programming | |||
Referencing variable | Excel Programming |