Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reference cells when looping
Using a loop like this
For Each tcell In Range("A4:A17").Cells If tcell.Value = "Danny" Then 'Write a value into column 2 columns to the right End If Next I want to write a value into the column 2 columns to the right of the current column and on the same row but I am not sure how to reference that cell in my code. So if I find the value "Danny" (as above) in cell A8 - I want to write the value "2" into cell A10. Any help appreciated Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping | Excel Discussion (Misc queries) | |||
Not Looping | Excel Discussion (Misc queries) | |||
Looping thru a range of cells | New Users to Excel | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
looping through an giving values to cells in vba | Excel Discussion (Misc queries) |