Hi,

I'm not sure if this is what you are intending but your offset formula
results in a range which begins in A1, is 6 columns wide and the number of
entries in column A deep. Can you please let me know why you've used the
range A1:F8 as the start range?

To use the named range in another sheet you can simply type it's name. e.g.
if you wished to add up all numeric entries in a range you could type =
SUM(myRange). How would you be using the range in your other sheet?

Thanks,
Matt

"Jon1205" wrote:

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