I want a command button that I can click. When it is clicked I want to make column of cells equal to a number in a certial cell if the cell in the column has "X 1D" in it. So lets say I paste a number 180 into cell D6. I have a column of cells D9-D22. When I click the button if a cell in D9-D22 has the value X 1D in it I want it to chenge that X 1D to 180. If the cell is blank leave it blank.