Hi,

On Sheet1 I want to be able to enter a Value in Column A and another
Value in Column B and have them concatenate in Column C with a } in
between them. I only want this to happen when Column A is Not Blank. If
only Column A has a Value then the result would be ColumnAValue}

I know I can do this with :
=IF(A1="","",CONCATENATE(A1,"}",B1))
but I really want to be able to do this with VBA code instead of a
formula. How do I do this?

Thanks Jody