| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a formual with " in it
Hi Mike,
I failed to include your fourth VLookup parameter, so change: ActiveCell.Formula = "=Right(""0000"" & c3,4) & " & _ "Vlookup(e3,'Bank Lookup'!$A2:$B$8,2)" to: ActiveCell.Formula = "=Right(""0000"" & c3,4) & " & _ "Vlookup(e3,'Bank Lookup'!$A2:$B$8,2,False)" --- Regards, Norman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting Rows...but losing "FORMAT" | Excel Discussion (Misc queries) | |||
| Inserting Auto Text for "Last Printed On" Date | Excel Discussion (Misc queries) | |||
| "Cannot shift objects off sheet" in Excel when inserting row/col? | Excel Worksheet Functions | |||
| When inserting column I get "cannot shift object off sheet" | Excel Worksheet Functions | |||
| inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions | |||
Threaded Mode
