View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wilson@irco wilson@irco is offline
external usenet poster
 
Posts: 15
Default concatenation w/in a macro

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.