changing formula - here is formula

[Alien]

=IF(M6>0.9,IF(M6<9,1.06,VLOOKUP(M6,$P$1:$Q$16,2)))

 

[Bob Phillips]

You could use the Find-Next button in that dialog to step over those that
you don't want to change. Not perfect, but probably quicker than manually.

Other than that it is VBA.

 

[Alien]

Select the cell you want to amend and any blank cell. Then Ctrl H will only
act on those 2 cells.

Andy

 

[Myrna Larson]

Hi, Bob:

In this situation, if an adjacent cell is blank, I've found it easiest to select the target cell
and the adjacent blank cell. Then the replacement will work only on those cells. If there's no
adjacent blank cell, it may or may not be worthwhile to insert a blank row or column, do the
replacement as described, then delete that added row/column.

 

[Bob Phillips]

Myrna,

I was unaware of that trick.

Even hearing it, I don't get it. Why/how does it work?

--

HTH

Bob Phillips

Hi, Bob:

In this situation, if an adjacent cell is blank, I've found it easiest to select the target cell
and the adjacent blank cell. Then the replacement will work only on those cells. If there's no
adjacent blank cell, it may or may not be worthwhile to insert a blank row or column, do the
replacement as described, then delete that added row/column.