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?

Thanks -- this is the code that works::

Dim myCol As Long
Dim myCell As Range

Set myCell = Cells.Find("Code")

If Not myCell Is Nothing Then
myCol = myCell.Column
End If

For Each c In Columns(myCol).Cells
.....
Next c