replacing a range of numbers

[sg]

in a group of cells i would like to replace all example i want to replace all
numbers >10. Everything tells me it cannot identify mty number

 

[Bob Bridges]

Seems to me we're missing some information here. Would this be what you
mean?: "I would like to identify a selected group of cells (eg C5:F10) and
place the character string 'XXX' in any cell of that group whose current
value is > 10. If the original looks like this:

C D E F
5 12 9 5 13
6 1 2 3 5
7 5 7 10 14
8 14 12 10 8
9 4 9 16 25
10 1 8 27 64

....afterward it should look like this:

C D E F
5 XXX 9 5 XXX
6 1 2 3 5
7 5 7 10 XXX
8 XXX XXX 10 8
9 4 9 XXX XXX
10 1 8 XXX XXX

Is this possible? When I try, Excel tells me it can't identify my number."

Try to ask your question (whatever it really is, because I doubt it's the
above) more exactly, in this mode.

 

[sg]

yes I know it is possible because i have seen the result, i just don't know how

 

[Don Guillett]

One way
Sub replacemorethan()
mc = "m"
For i = 1 To Cells(rows.Count, mc).End(xlUp).Row
If Cells(i, mc) > 10 Then Cells(i, mc) = 1000' or whatever
Next i
End Sub