Thread: [Solved] HOW TO write a macro for dynamic relative named ranges in Excel?
View Single Post
 
Old 01-25-2022, 02:00 AM
NoSparks NoSparks is offline Windows 10 Office 2010
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
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
Reply With Quote