| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enter a formula ?
When I use:
Range("E1").Formula = "=A1*10" No problem. When I enter in the spread sheet: =LEFT(A1,SEARCH(" - ",A1)-1) No problem. But when I use: Range("E1").Formula = "=LEFT(A1,SEARCH(" - ",A1)-1)" I get "Run-time error 13:. How can I have VBA enter the second formula ? Thank you, Emory |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to enter a formula ?
Hi
Range("E1").Formula = "=LEFT(A1,SEARCH("" - "",A1)-1)" "" - "" Double them -- Regards Ron de Bruin http://www.rondebruin.nl "Emory Richter" wrote in message m... When I use: Range("E1").Formula = "=A1*10" No problem. When I enter in the spread sheet: =LEFT(A1,SEARCH(" - ",A1)-1) No problem. But when I use: Range("E1").Formula = "=LEFT(A1,SEARCH(" - ",A1)-1)" I get "Run-time error 13:. How can I have VBA enter the second formula ? Thank you, Emory |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to enter a formula ?
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to enter a formula ?
Range("E1").Formula = "=LEFT(A1,SEARCH("" - "",A1)-1)"
When you use double quotes within a text string you have to enter two double quotes to get one. -- Regards, Tom Ogilvy "Emory Richter" wrote in message m... When I use: Range("E1").Formula = "=A1*10" No problem. When I enter in the spread sheet: =LEFT(A1,SEARCH(" - ",A1)-1) No problem. But when I use: Range("E1").Formula = "=LEFT(A1,SEARCH(" - ",A1)-1)" I get "Run-time error 13:. How can I have VBA enter the second formula ? Thank you, Emory |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to enter a formula ?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| When I enter a formula it shows the formula not the result | Excel Discussion (Misc queries) | |||
| can you wrap formula results via a formula eg. Alt Enter | Excel Discussion (Misc queries) | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
| Cannot enter formula in a cell after removing a circular formula | Excel Worksheet Functions | |||
Linear Mode
