I am wanting first to name a group of cells like A1:F8 and then link that
name to another sheet. I tried to name the group using the equation:
=OFFSET(sheet1!$A$1:$F$8,0,0,COUNTA(sheet1!$A:$A), 6)
Is this the right eqation or am I missing something. Then how do I link
that name to another sheet.

thanks