+ Reply to Thread
Results 1 to 3 of 3

How to make variables reference different cells

  1. #1
    Forum Contributor
    Join Date
    02-20-2017
    Location
    Indiana
    MS-Off Ver
    2016
    Posts
    101

    How to make variables reference different cells

    I'm trying to make some variables reference different cells as the code loops through. I'm just not sure how to format the i variable into existing variables. For example, I'm trying to make the WBS variable reference A2 the first loop through. Then A3 the second loop through and so on.

    Please Login or Register  to view this content.
    Last edited by BryceVBA; 04-26-2017 at 10:36 AM.

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: How to make variables reference different cells

    Please Login or Register  to view this content.
    I'm interested in starting a career working with VBA, if anyone knows of any opportunities!

  3. #3
    Forum Contributor
    Join Date
    02-20-2017
    Location
    Indiana
    MS-Off Ver
    2016
    Posts
    101

    Re: How to make variables reference different cells

    Works. Thanks much!

+ 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. How can I make absolute reference only cells that referenced from another sheet??
    By marins0330 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2017, 09:01 AM
  2. How to make a formula dynamically reference another set of cells?
    By ShootingBlanks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2016, 04:59 PM
  3. Replies: 3
    Last Post: 02-27-2014, 02:31 PM
  4. Replies: 0
    Last Post: 03-08-2013, 06:34 AM
  5. how to make 3 cells as reference to each other
    By KALATRASH81 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-04-2013, 03:41 AM
  6. Replies: 3
    Last Post: 07-16-2009, 12:40 AM
  7. Can I link cells to a reference table I make?
    By EZimm in forum Excel General
    Replies: 1
    Last Post: 05-04-2005, 07:06 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