Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FIND function driving me nuts
I've been trying to get a FIND working in Excel 2003 which I remember
working fine earlier, but for some reason this attempt has been an effort in futility. Here's the code generated by recording a macro and CTRL-F to find the text I'm looking for: Cells.Find(What:="2005.12.07", After:=ActiveCell, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Running that code immediately after generating it returns an error! So does every attempt at using it. I cannot believe that I've discovered a bug. It works fine from the UI, but dies in VBA. HELP! Thanks; Duncan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help, this is driving me nuts | Excel Discussion (Misc queries) | |||
Today function is driving me nuts | Excel Worksheet Functions | |||
question driving me nuts | Excel Discussion (Misc queries) | |||
Sum and Count are driving me nuts!! | Charts and Charting in Excel | |||
Driving me nuts. Need more nested than 7 | Excel Discussion (Misc queries) |