|
|
#4
01-25-2022, 02:00 AM
|
|||
|
|||
I only re-wrote what you already had so that vba would recognize the variables
You made up the formula When I create the dynamic range manually the Refers to formula is =Sheet1!$A$2:INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$ A)) (There is no space before the last A the forum software is inserting it) Last edited by NoSparks; 01-25-2022 at 10:08 AM. Reason: added manually created info 
|
| Tags |
| address, macro, relative named ranges |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Use of named ranges based on cell content | Intruder | Excel | 12 | 02-25-2019 09:42 AM |
 Named Ranges Help
|
SavGDK | Excel | 5 | 05-01-2017 09:41 AM |
| How to use named ranges in excel vba? | bosve73 | Excel Programming | 4 | 01-25-2012 09:26 AM |
| Dynamic Named Ranges using text | hannu | Excel | 0 | 06-22-2010 04:42 PM |
| Can't import home adresses in outlook 2010 from excel named ranges | eekie | Outlook | 0 | 05-14-2010 02:04 PM |
Windows 10 
Office 2010
Threaded Mode