Thread
:
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
View Single Post
#
6
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
Sub insertslash()
With Range("A1")
..NumberFormat = "# ?/?"
..Value = Range("a2") & "/" & Range("b2")
End With
End Sub
--
Don Guillett
SalesAid Software
wrote in message
oups.com...
Hey--Thanks for the help guys. The syntax you gave works for inserting
characters like 'a' in between the values, but for some reason it is
still dividing when I try to insert the /. Any ideas about what is
going on?
My code, exactly:
Sub test()
[a1] = [a11] & "/" & [a9]
End Sub
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett