Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate with Underscore in formula
Hi All.....
I am trying to use VBA to place a formula in a cell that is a concatenation of two cells using an underscore between them. The formula works fine when used on the sheet, but VBA balks at the underscores.......is there some special combination of characters to allow the underscore..... My code reads something like this formula = "=A1&"_"&B1" Any help would be appreciated, Vaya con Dios, Chuck, CABGx3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate with Underscore in formula
I think you problem is not with the underscore, but trying to embed double
quotes within you string formula = "=A1&""_""&B1" ? formula =A1&"_"&B1 so double your double quotes when used within a string -- Regards, Tom Ogilvy "CLR" wrote in message ... Hi All..... I am trying to use VBA to place a formula in a cell that is a concatenation of two cells using an underscore between them. The formula works fine when used on the sheet, but VBA balks at the underscores.......is there some special combination of characters to allow the underscore..... My code reads something like this formula = "=A1&"_"&B1" Any help would be appreciated, Vaya con Dios, Chuck, CABGx3 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate with Underscore in formula
Cool Tom.........thanks many bunches, that solved the problem. My actual
formula was a long IF-VLOOKUP string and also included a null "" thing that needed the same treatment. I much appreciate your help...... Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote: I think you problem is not with the underscore, but trying to embed double quotes within you string formula = "=A1&""_""&B1" ? formula =A1&"_"&B1 so double your double quotes when used within a string -- Regards, Tom Ogilvy "CLR" wrote in message ... Hi All..... I am trying to use VBA to place a formula in a cell that is a concatenation of two cells using an underscore between them. The formula works fine when used on the sheet, but VBA balks at the underscores.......is there some special combination of characters to allow the underscore..... My code reads something like this formula = "=A1&"_"&B1" Any help would be appreciated, Vaya con Dios, Chuck, CABGx3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
underscore in functions | Excel Worksheet Functions | |||
underscore in email address covered by hyperlink underscore | Excel Discussion (Misc queries) | |||
How can I double underscore in excel? | Excel Worksheet Functions | |||
Underscore in Excel Title Bar | Excel Programming | |||
Underscore character _ | Excel Programming |