Thread: Mix of relative and absolute?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M John M John is offline
external usenet poster
  
Posts: 35
Default Mix of relative and absolute?
I'm working on a macro that has the following line:

ActiveCell.FormulaR1C1 =
"=CONCATENATE(CHAR(10),RC[-3],CHAR(10),RC[-2],CHAR(10),RC[-1])"

And I want to insert text before the first character return...as in:

ActiveCell.FormulaR1C1 =
"=CONCATENATE("text",CHAR(10),RC[-3],CHAR(10),RC[-2],CHAR(10),RC[-1])"

Is this possible?
Thanks,
M John
Reply With QuoteReply With Quote