How do I convince the cursor to select a given cell when in a macr

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

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