Range across worksheets

  • Thread starter Thread starter reab
  • Start date Start date
R

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
 
reab said:
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.
Click to expand...

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.
 
Back
Top