| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convince the cursor to select a given cell when in a macr
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select cell containing specific text &return value from another ce | Excel Worksheet Functions | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Macro for cell select | Excel Discussion (Misc queries) | |||
| How do you control scroll rate when click and drag to select cell | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
