rc notation variable

  1. R

    RC Notation using a variable?

    The following vba line successfully inserts a Substitute Formula into one cell that refers to another cell 46 columns to the left: ActiveCell.FormulaR1C1 = "=SUBSTITUTE(RC[-46],BoxPipe2,""|"")" I want to replace the 46 with a numeric variable called 'nc'. But I get an error when I try to run...

Some videos you may like

This Week's Hot Topics