Concatenating literal, with ActiveCell and FormulaR1C1

**LydiasDad** · 06-29-2011, 05:30 PM

I can't find a way to do this. If I don't use the literal "R", it works fine, but I need that R. Any ideas? Here's my line:

Please Login or Register  to view this content.

I want to concatenate an "R" at the end. How to do it?

If I just try to add

& "R"

I get "Application-defined or object-defined error. "

**Paul** · 06-29-2011, 05:40 PM

Hi LydiasDad, try adding a few more quotation marks, like so:

Please Login or Register  to view this content.

Also, be sure to wrap code within [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags.

**LydiasDad** · 06-29-2011, 06:10 PM

OK, that worked. Thanks. That was the first step. I thought I could use that example to get the whole thing working, but no luck. Here's what I really want (calculating a remainder).

ActiveCell.FormulaR1C1 = "=INT( R[-2]C/R[-1]C)&"" R"" &(R[-2]C - R[-1]C * INT ( R[-2]C / R[-1]C ))"

So, if R[-2]C is 4, and R[-1]C is 3, I should get "1 R1" (one, remainder one) as the answer. But I still get that same error.

**Paul** · 06-29-2011, 06:23 PM

Try removing all spaces from your formula except where you want a literal space before the R. A good way to see what the formula should be is to record a macro while typing the formula (in A1 style) into a cell.

Please Login or Register  to view this content.

Start the macro recorder, then in C3 type:

=INT(C1/C2)&" R"&(C1-C2*INT(C1/C2))

Stop the macro recorder and open the VB Editor. View the code created in the module and you should see the formula in R1C1 notation.