| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| absolute & relative references | Excel Discussion (Misc queries) | |||
| Relative and absolute hyperlinks | New Users to Excel | |||
| Absolute vs Relative path | Excel Discussion (Misc queries) | |||
| Absolute / Relative References | Excel Programming | |||
| Chg Absolute to Relative | Excel Programming | |||
Threaded Mode
