If I changed the : to a -, I could get past the initial compiling error.
So I may have an additional problem. I also have a "Run time error '13';
type mismatch"
Please respond to both errors.


"iashorty" wrote:

I am using the following
ActiveCell.FormulaR1C1 = "=CONCATENATE(PriorYear&" - "&PriorMonth&":
"&VLOOKUP(RC[-26],'Prior Month'!R9C1:R1009C12,12,FALSE),CHAR(10),'Prior
Month'!RC[-17])"

to pull in prior month commentary and adding a date stamp with a COLON
between the two.
The above should look like: 2007-08: This situation...
The colon in not being accepted. What is the string to insert a colon as
text in this formula?