Concatenate formula in VBA

[sefMI]

Anyone know how to write this formula in vba using the activecell.row method instead of the hard code? =CONCATENATE(E4," ",G4)
I'm having trouble coding the ," ", space, vba keeps flipping out at me :wink:
I know I could use & to make it a value in the cell, but I need it to be a formula because G4 is a date that changes.

 

[Richard Schollar]

Perhaps:

Range("A1").FormulaR1C1 = "=RC5 & " & Chr(34) & " " & chr(34) & " & RC7"

Best regards

Richard

 

[sefMI]

Thanks.
Is there a list of the various chr(##) and what they do? I tried looking it up in the object browser, no luck.

 

[Richard Schollar]

Sure, try the VBA Help under Miscellaneous - you're looking for the character sets.

Alternatively, do a Google search for ASCII codes.

Best regards

Richard