Results 1 to 9 of 9

How to reference an expanding range?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-29-2013
    Location
    US
    MS-Off Ver
    Office 2016
    Posts
    109

    How to reference an expanding range?

    I have a simple worksheet that I use as a daily calorie counter. And I have a macro that I use to clear it each morning. The problem is that I'm constantly adding new items to the worksheet, so the number of rows and the range that needs to be cleared grows. It can also shrink if I remove something.

    I could use a function to count items, but I also have a few blank rows for readability. How best to approach this?
    Last edited by Carson Dyle; 11-09-2016 at 06:03 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Expanding Range Problem
    By horneblower in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2014, 06:24 AM
  2. For each cell in range loop does not recognize expanding range
    By jhren in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2013, 07:49 AM
  3. Expanding Cells - Click on Reference
    By curtjer in forum Excel General
    Replies: 1
    Last Post: 04-06-2012, 10:37 PM
  4. Excel 2007 : Expanding columns with sheet-reference
    By halbooth in forum Excel General
    Replies: 0
    Last Post: 10-31-2011, 06:45 PM
  5. Expanding a complex range reference
    By bob lad in forum Excel General
    Replies: 5
    Last Post: 03-05-2010, 12:01 PM
  6. expanding range for sort
    By aupeter in forum Excel General
    Replies: 1
    Last Post: 09-22-2008, 12:58 AM
  7. [SOLVED] Expanding conditional formating with reference cells changing
    By CCoop in forum Excel General
    Replies: 2
    Last Post: 05-04-2005, 10:06 AM

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