Range across worksheets

[reab]

I would like to create a named range across two
worksheets in the same workbook. After creating the
named range I would like to use it as a data source for a
mail merge in Word 2002.

Any help appreciated

 

[Harlan Grove]

I would like to create a named range across two
worksheets in the same workbook. After creating the
named range I would like to use it as a data source for a
mail merge in Word 2002.

Not possible. Ranges are restricted to *SINGLE* worksheets. There is no
work-around. You may want to refigure your whole concept. You'd only need
more than one worksheet if you have more than 256 fields. If you have a form
letter that pulls more than 256 fields, you're BEGGING for problems.