| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to insert "&" in a formula using VBA?
Hi all,
My question is as followed. Now the content of A2 cell is a formula like this: =BLP(A1&" "&B1, "CLOSE_DATE") Now I want to insert this formula using VBA. The range is from C1 to C10. So I code like this: for i=1 to 10 Range("C" & i).Formula="=BLP(A" & i & "&"" ""&B" & i &",""CLOSE_DATE"")" next i But it reports error. What is the correct formula then? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| Is there a formula thet reads (If A2=A1,"",INSERT PAGE BREAK) ? | Excel Discussion (Misc queries) | |||
| If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
| Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming | |||
Threaded Mode
