Hi
you may post your existing macro.
But as an example try
...
dim rng as range
set rng = columns(3)
'or
'set rng = range("C:C")
for each c in rng
'....


--
Regards
Frank Kabel
Frankfurt, Germany


WintonCW wrote:
I have written a macro that highlights numbers in a given range (for
each c in <range)

However, I can't figure out how to set the range to only a specific
column
I have found the column number using a cells.find(), but how do I set
the range?