| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find problem
Hi i got some advice from Chip Pearson on Friday on the
find method... Dim FoundCell As Range Set FoundCell = Cells.Find(....) If Not FoundCell Is Nothing Then ' Find was successful, do something with FoundCell Else ' Not Found End If .... This still doesn't seem to work when using it up to 12 times in a loop. is there anything you have to put in in this situation. I'm sorry if this is very simple, but i think i do need it spelling out for me. I need to find the beginning and end of a section of data, see below... apple apple apple apple pear pear pear orange banana banana banana .... and export each section to a different file, which i can do. I'm sorry to be annoying, but it's on a deadline and i'm tearing my hair out. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with 'Find' | Excel Discussion (Misc queries) | |||
| Find-Replace problem | Excel Discussion (Misc queries) | |||
| Find replace problem | Excel Discussion (Misc queries) | |||
| problem with FIND | Excel Worksheet Functions | |||
| Problem with FIND | Excel Programming | |||
Threaded Mode
