Hi Kb24,

Try this, if I understand you the idea is your trying to switch around two numbers based on the value of the first...

The example will switch all number 3s in the range with the number 6, expand upon this yourself by copying the 'case' and the line below it replacing the values to find and replace.

PHP Code: 
Sub ChangeValues()

Dim Beta As Range
Dim cell As Range

Set Beta = Range("A1:A7")

    For Each cell In Beta

    Select Case cell.Value

              Case 3

              cell.Value = 6

    End Select

    Next

End Sub 
Drew