Results 1 to 3 of 3

Formula R1C1

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-14-2004
    Location
    India
    MS-Off Ver
    365
    Posts
    264

    Question Formula R1C1

    Hi I am sorry for not using the RULES for the codes. I hereby edit my post.
    Thanks


    Hello
    I am tired of reading the cell reference using FormulaR1C1 method in macros. like

    Range("L4").Select
     ActiveCell.FormulaR1C1 = "=RC[-4]-RC[-2]"
    Is there any way it can show the normal cell reference
    like

    " =J-H"  instead of "=RC[-4]-RC[-2]".
    Thank u

    Toms
    Last edited by SMILE; 08-26-2010 at 05:15 AM.

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