Thread
:
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
View Single Post
#
5
Posted to microsoft.public.excel.programming
Zone
external usenet poster
Posts: 269
The syntax for programmatically inserting a "/" in the middle of a concatenated cell
The code works fine for me. I cannot see how the two numbers are being
divided unless A1 begins with =. Check A1 and make sure it doesn't
begin with =. Then post back. Maybe Don has an idea. James
wrote:
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
Zone
View Public Profile
Find all posts by Zone