| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula on two or more lines
Hi,
I am using a mcro to place a formula into a cell and whilst the example below isn't too long, I would like to have this over a couple of lines. I have tried placing a space and an underscore in the formula as a line break but the formula errors. Do formulas need to be on a single line? ..Formula = _ "=TRIM(MID(VLOOKUP(""H0""&LEFT(A1,3),'[" & IName & "]Sites'!Data,2,False),9,50))" Thanks, Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with a formula (Multiple lines to sum and return if) | Excel Discussion (Misc queries) | |||
| copy formula down 1000,s of lines | Excel Worksheet Functions | |||
| Formula to differentiate between product lines | Excel Discussion (Misc queries) | |||
| Sub to copy only result lines within formula range, omit null string lines | Excel Programming | |||
| Formula: Add rows/lines to destination in Hyperlink | Excel Discussion (Misc queries) | |||
Linear Mode
