jmcginley3
New Member
- Joined
- Mar 28, 2018
- Messages
- 14
I'm trying to figure out how I can use Cells.Replace along with Offset to locate and replace the cells that contain the text "Auto Adjustments" and replace it with the value of the cell directly above it.
<tbody>
</tbody>
Can I use this and insert some kind of offset coding into the Replacement?
450 | |
Auto Adjustments | <--- this Cell is changed to the value of the cell right above it (450) |
564 | |
45433 | |
56788 | |
9084 | |
Auto Adjustments | <---- this Cell is changed to the value of the cell right above it (9084) |
56165 | |
8765 | |
Auto Adjustments | <---- this Cell is changed to the value of the cell right above it (8765) |
<tbody>
</tbody>
Can I use this and insert some kind of offset coding into the Replacement?
Code:
Cells.Replace What:="Auto Adjustments", Replacement:="?????", LookAt:= xlPart, SearchOrder:=xlByRows