+ Reply to Thread
Results 1 to 4 of 4

Another Question About R1C1 Notation in VBA

  1. #1
    Registered User
    Join Date
    03-18-2014
    Location
    Huntsville, AL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Another Question About R1C1 Notation in VBA

    Greetings to all,

    I hope this is relatively simple to answer,

    Is the VBA Statement

    Please Login or Register  to view this content.
    the same as stating

    Please Login or Register  to view this content.
    ????

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Another Question About R1C1 Notation in VBA

    Don't know if this clears anything up. They both do the same thing by making the activecell blank. However one R1C1 does it with a formula and .value places an actual value of blank into the cell. The results are exactly the same.

  3. #3
    Registered User
    Join Date
    03-18-2014
    Location
    Huntsville, AL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Thumbs up CLOSED: ANSWERED: Re: Another Question About R1C1 Notation in VBA

    Hey,

    Thank you Mr. John Davis for your answer. I was pretty sure they did the same thing, but wanted to check with the experts first.

    Thanks again.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: CLOSED: ANSWERED: Re: Another Question About R1C1 Notation in VBA

    You're welcome. Glad to help out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] What is the advantage of A1 or R1C1 Notation ?
    By nur2544 in forum Excel General
    Replies: 1
    Last Post: 02-08-2013, 12:18 PM
  2. [SOLVED] How to use named ranges in R1C1 notation?
    By wolis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2012, 11:13 AM
  3. R1C1 notation conversion
    By Impartial Derivative in forum Excel General
    Replies: 1
    Last Post: 06-16-2011, 06:04 PM
  4. Sum Columns:R1C1 notation
    By Zone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2006, 11:05 AM
  5. R1C1 Notation in VBA
    By Fred Holmes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2005, 05:05 PM

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