+ Reply to Thread
Results 1 to 3 of 3

Cell address in formulas

  1. #1
    Forum Contributor
    Join Date
    09-02-2005
    Posts
    146

    Cell address in formulas

    I'm updating a workbook that I did a while back and hoping to overcome a problem I wasn't brass enough to take on before.

    Previously, because I didn't know how to set formulas to change sideways, so I just setup the workbook to go up and down. But it displays better going sideways, so I'd like to find a way to do it that way.

    My current code looks like this:
    Please Login or Register  to view this content.
    For that code, it would cycle with "i" and move down one row at a time.

    Now I want to do the same thing, but instead of moving down, I want to move over. This means that as "i" increases my "=C" becomes "=D" then "=E" ....

    I'm not aware of a way to enter formulas using a .cells(x,y) notation. What ideas do y'all have? The best I can come up with is a secondary function that converts 1 to A, 2 to B, 3 to C, etc.
    Last edited by wilro85; 04-05-2010 at 12:03 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Cell address in formulas

    For the first example, you can do,
    Please Login or Register  to view this content.
    ... or just
    Please Login or Register  to view this content.
    Not sure what you're trying to do now.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    09-02-2005
    Posts
    146

    Re: Cell address in formulas

    Yes. That is exactly what I was looking for. Thank you.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1