| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Find command
I'm trying to use "Find" to determine the exact location of a space in a
string. (e.g. Smith Bob space is located in postion 6) In code I'm entering ActiveCell.Formula = "=Find(" ",D3,1)" to determine the space location. It errors every time. I believe it has to do with the quotation marks. This works fine as a formula in the spreadsheet, but in VBA an error occurs. Any ideas on why I get an error? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND command | Excel Discussion (Misc queries) | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
| Find Command | Excel Programming | |||
| Find Command | Excel Programming | |||
| Find Command | Excel Programming | |||
Threaded Mode
