PDA

View Full Version : Solved: Creating Dynamic Named Range



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:

Bob Phillips
08-29-2008, 06:38 AM
=OFFSET(Sheet1!$G$2,0,0,1,COUNTA(Sheet1!$G$2:$IV$2))