I have created a value for a range which i reference in a macro that
creates a pivot table. We add new data each month and generate a new
table so we needed to keep the range of cells dynamic.

Here is the definition for the name i use:

=OFFSET('C:\Monthly Stat Project\[I&RC Monthly Stats Count
TEST.xls]MonthlyCount_data'!$A$1,0,0,COUNTA('C:\Monthly Stat
Project\[I&RC Monthly Stats Count
TEST.xls]MonthlyCount_data'!$A:$A),6)

What i want to do is remove the reference to the location of the
workbook "C:\Monthly Stat Project\[I&RC Monthly Stats Count TEST.xls]"

and instead have it just reference the current workbook. Is there a
way to do this?

something along the lines of: =OFFSET(CURRENT WORKBOOK
MonthlyCount_data'!$A$1,0,0,COUNTA(CURRENT WORKBOOK
MonthlyCount_data'!$A:$A),6)


Any help would be greatly appreciated.

Thanks


--
captainwicked
------------------------------------------------------------------------
captainwicked's Profile: http://www.excelforum.com/member.php...o&userid=36369
View this thread: http://www.excelforum.com/showthread...hreadid=569980