Bad Syntax

[jim may]

Is the following fixable?

=OFFSET(INDIRECT(" ' "&My Main&" '!"&"$A$2"),0,0,COUNTA(Main!$A:$A)-1,1)

 

[jim may]

I've since modified to: (This is being entered into the RefersTo Box of the RangeName Define window)

=OFFSET(INDIRECT(" ' "&Main&" '!"&"$A$2"),0,0,COUNTA(INDIRECT(" ' "&Main&" '!"&$A:$A))-1,1)

Still -- "No Cigar" !!!

 

[RoryA]

What is Main? The name of a sheet or a defined name containing the name of the sheet?

 

[jim may]

Thanks -- I see the confusion.. Sorry.. my Second post should have referred to My Main (the name of my Sheet).

 

[RoryA]

Can't see why you're using INDIRECT then, but:

=OFFSET(INDIRECT("'My Main'!$A$2"),0,0,COUNTA(INDIRECT("'My Main'!$A:$A"))-1,1)

 

[jim may]

Rory,
Thank you SO MUCH!!
JIm