Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
Hello--Does anyone know the syntax for programatically inserting a "/"
between the two added numbers of a concatenated cell? I want the value of, say, Range("a1") to equal the value of range ("a2") "/" range ("a3"). What is the syntax for telling excel to insert the slash? A stripped down version of my code looks like this : Sub Concat() Range("a1").Formula = "=Value(A2&A3)" End Sub I want the "/" between A2 and A3. Does anyone know the syntax? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
whyis "paste spl" copying concatenated cell changing lastdigit2 0 | Excel Worksheet Functions | |||
inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions |