'=OFFSET(Don!$A$5,1,0,1,3),OFFSET(Don!$A$5,3,0,1,3 )

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
If desired, send your wb to my address below along with snippets of these
msgs inserted into a worksheet and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Hi Barb and Don,
Sorry for leaving the thread awhile; needed travel and sleep. The
data on a sheet applies to one class. The named ranges are for a
Worksheet_Change event that programmatically validates possible
combinations of scores past column AR. I only formatted the sheets to
extend down to row 60; this would more than hold the max number of
students + additional students for a class in a semester. And, yes,
columns would've been nice; a database even nicer, but making the data
go horizontal would've run into Excel's # of column limitation.
Thanks again.