Results 1 to 5 of 5

Concatenating literal, with ActiveCell and FormulaR1C1

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2011
    Location
    Atlanta, GA
    MS-Off Ver
    MS365, vsn 16.0.17909.42302
    Posts
    45

    Concatenating literal, with ActiveCell and FormulaR1C1

    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:

    ActiveCell.FormulaR1C1 = "=R[-2]C / R[-1]C"
    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. "
    Last edited by Paul; 06-29-2011 at 05:40 PM. Reason: Added code tags.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1