| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
assign formula to a cell
hi. i want to do this:
Worksheets("sheet1").Range("init").Offset(1, -1) = "=blp("SPX Index","last price")" but i cant because excel assumes the formula terminates on the second ", therefore assuming the formula is =blp( can you help me out? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
assign formula to a cell
Worksheets("sheet1").Range("init").Offset(1, -1) = "=blp(""SPX
Index"",""last price"")" Regards Trevor "ALVESM" wrote in message ... hi. i want to do this: Worksheets("sheet1").Range("init").Offset(1, -1) = "=blp("SPX Index","last price")" but i cant because excel assumes the formula terminates on the second ", therefore assuming the formula is =blp( can you help me out? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
assign formula to a cell
hi.
not sure. =blp does not look like a standard excel function suggesting that it might be a user defined function. post the UDF. lunch. Regards FSt1 "ALVESM" wrote: hi. i want to do this: Worksheets("sheet1").Range("init").Offset(1, -1) = "=blp("SPX Index","last price")" but i cant because excel assumes the formula terminates on the second ", therefore assuming the formula is =blp( can you help me out? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
assign formula to a cell
blp is a function that uses third party software via ddl links. the software
in question is bloomberg which is a market data feeder. i think the previous post sorted it out. cheers "FSt1" wrote: hi. not sure. =blp does not look like a standard excel function suggesting that it might be a user defined function. post the UDF. lunch. Regards FSt1 "ALVESM" wrote: hi. i want to do this: Worksheets("sheet1").Range("init").Offset(1, -1) = "=blp("SPX Index","last price")" but i cant because excel assumes the formula terminates on the second ", therefore assuming the formula is =blp( can you help me out? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
assign formula to a cell
.....Offset(1, -1) = "=blp("SPX Index","last price")"
In a String constant (delineated by quote marks surrounding it), internal quote marks must be doubled up. So, your code should look like this... ......Offset(1, -1) = "=blp(""SPX Index"",""last price"")" That is the rule for all String constants, not just for the way you used it here. Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I assign a value to a cell without putting a formula in it | Excel Worksheet Functions | |||
| Formula - assign a cell to show the next | Excel Worksheet Functions | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| How to create a formula in VBA to assign to a cell | Excel Programming | |||
| Change cell formula & assign to VBA variable... | Excel Programming | |||
Hybrid Mode
