+ Reply to Thread
Results 1 to 4 of 4

R1C1 Formulas

  1. 10-17-2007, 01:25 PM #1
    thundermocos
    thundermocos is offline
    Registered User
    Join Date
    10-11-2007
    Posts
    11

    R1C1 Formulas

    I am having a problem figuring out how to get the R1C1 forumula to accept a changing value. What I am trying to do is get a macro to calculate the average value of a column on a spreadsheet. However the number of columns changes depending on the spreadsheet. So I want it to count the columns and based on the number of columns counted, calculate the average for as many columns are on the spreadsheet. 
    Please Login or Register  to view this content.
    How could I get VBA to accept columncount as a numerical value for the "R1C1Formula =" ?
    Last edited by thundermocos; 10-17-2007 at 03:57 PM.
    Reply With QuoteRegister To Reply
  2. 10-17-2007, 01:41 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello thundermocos,

    Please read the forum rules about wrapping your code. If youfail to do so, your post may be locked by the administrators.

    Forum Rules

    Sincerely,
    Leith Ross
    Reply With QuoteRegister To Reply
  3. 10-17-2007, 02:47 PM #3
    thundermocos
    thundermocos is offline
    Registered User
    Join Date
    10-11-2007
    Posts
    11
    I am sorry Leith, I do not understand what I did wrong. I am removing the code, my apologies. I read the Forum Rules in your post, still clueless.. sorry
    Reply With QuoteRegister To Reply
  4. 10-17-2007, 03:21 PM #4
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello thundermocos,

    You can manually place the code tags around your code, or select the code and click on the # symbol located above the message window. Have a look at this link for ways to use HTML code tags in your posts...

    HTML code tags

    Sincerely,
    Leith Ross
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1