Thanks

Can you give me the exat syntax -- im not to good on VBA.

Regards

John Baker

"Bob Phillips" wrote:

John,

Try a name with a RefersTo value of something like

=Sheet1!$A$1:OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A: $A)-1,0)