Turn on the macro recorder.
select your column
edit|find

turn off the recorder and look at the code.

Wulliam wrote:

I have a column of numbers - all zero's except for one '1'. Depending on the
situation, the '1' can appear anywhere in the column. What do I do (manually)
to find that particular cell automatically? I want to record a macro with
this in it.

Hoping this makes sense!
Regards,
William

--

Dave Peterson