Home |
Search |
Today's Posts |
#1
|
|||
|
|||
substitute
How can I substitute each instance of "B" in a range (B4..g22) with the value
in Column A same row as the Corresponding "B". Not all cell in range have the "B" Al |
#2
|
|||
|
|||
With VBA
For Each cell In Range("B2:G22") If cell.Value = "B" Then cell.Value = Cells(cell.Row,"A").Value End If Next cell -- HTH Bob Phillips "AMK" wrote in message ... How can I substitute each instance of "B" in a range (B4..g22) with the value in Column A same row as the Corresponding "B". Not all cell in range have the "B" Al |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a VLOOKUP substitute when data is not in ascending order | Excel Worksheet Functions |