I'm trying to perform a concatenation within a macro using the recording fn,
but the syntax written into the macro is:

+"*"&R[-1]C&"*"

and once I copy this macro into my file, the concatenation obviously doesn't
work.

The concatenation is to generate barcode fields for the data in the cell
above. so, it looks like +"*"&A2&"*" (given my source data is in cell A2).

why is the macro converting this to +"*"&R[-1]C&"*"? Thanks.