CreganTur
08-29-2008, 06:29 AM
I'm trying to create a dynamic named range through the Define Name dialog box. MD posted a great example (http://www.vbaexpress.com/forum/showpost.php?p=156718&postcount=7) of how to do this when your named range is vertical, but now I'm trying to create a horizontal dynamic named range.
The range starts at G2 and I want to set it so that it will count left from IV2 to the last used cell. Here's the function I thought would work based on studying MD's example:
=OFFSET(Sheet1!$G$2,0,0,0,COUNTA(Sheet1!$G2:$IV2))
Where am I going wrong? :think:
The range starts at G2 and I want to set it so that it will count left from IV2 to the last used cell. Here's the function I thought would work based on studying MD's example:
=OFFSET(Sheet1!$G$2,0,0,0,COUNTA(Sheet1!$G2:$IV2))
Where am I going wrong? :think: