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

W

Wulliam

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
 
D

Dave Peterson

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

turn off the recorder and look at the code.
 
Top