Expanding a named range

  • Thread starter Thread starter cmdx3
  • Start date Start date
C

cmdx3

Can anyone help me with coding an automated expansion of a named range
please? Here's my situation:

I have a range, 2 columns, 5 rows, which I set up as a named range.
When someone else enters information in the next row, it is not
automatically included in the named range. What I'm looking for is a
code that will automatically expand the named range to include the new
cells. It would probably look for the first blank row and stop just
prior to that blank row.

Any help is greatly appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Post my named ranges in column A 10
Multiple Dynamic Named Ranges across Columns 3
i = row number of last occurance of duplicate string Column A 4
Select a specific row in named range 7
Modify working code to expand the output. 5
Check a range to see if a value exists in it 5
Named Range maker code 9
Code to name numerous ranges 11

Back
Top