| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula error, vba not liking commas
I am trying to put the following formula into a piece of code (using the variable 'sFormula' to hold the formula) and get the error message as below, any ideas how i can get around this. I know i could place it on the worksheet somewhere and copy it but would like to keep it in code if possible sFormula="=IF(LEFT(RIGHT(A7,2),1)=",","."&RIGHT(A7 ,1),"")" "Compile error expected end of statement" it appears not to like the first comma in inverted commas Any ideas will be gratefully received -- with kind regards Spike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add commas to the result of a formula with a text operator? | Excel Discussion (Misc queries) | |||
| Formula to Add $ and/or commas | Excel Worksheet Functions | |||
| Help! I need a formula to add numbers separated by commas within | Excel Worksheet Functions | |||
| formula to count commas | Excel Discussion (Misc queries) | |||
| Autoselection of Spreadsheet for liking | Excel Discussion (Misc queries) | |||
Threaded Mode
