View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] akh2103@gmail.com is offline
external usenet poster
 
Posts: 28
Default 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?