| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert " " into a string
I am inserting formulas into cells using a macro. Several formulas require a
blank. (" ") Ex1: Sheets("Frame 6").Range("G3").Value = "=IF(ISERROR(VLOOKUP(A3," & CSpath & ",29,FALSE))," ",VLOOKUP(A3," & CSpath & ",29,FALSE))" Ex2: Sheets("Frame 6").Range("F3").Value = "=IF(D3=1,VLOOKUP(A3," & CSpath & ",34,FALSE)," ")" However, Excel won't let you do this. How can I get the blanks in there? Thanks in advance. -Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| insert "-" as fourth character in number string | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
| Macro to insert "0" in front of 4 character string | Excel Programming | |||
Threaded Mode
