| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Avoid re-entering 'Find what:'
Col A contains a list of dates. In Cell B1 I enter a single date. How do I
write a macro to find the cell in Col A with the date which matches B1 and make it the Active Cell. I could use Edit/Find but do not want to re-enter the B1 date in 'Find what:'. I want the macro to use the B1 date automatically. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to avoid name ref in formula? | Excel Discussion (Misc queries) | |||
| How to avoid #DIV/0 from appearing | Excel Discussion (Misc queries) | |||
| Where can I find { } that I need to use for entering a constant? | Excel Discussion (Misc queries) | |||
| what is this, how do I avoid it? | Excel Discussion (Misc queries) | |||
| Why does Help go to network? How to avoid it? | Excel Discussion (Misc queries) | |||
Threaded Mode
