Thread
:
Deleting rows messes up Named Ranges--How can this be fixed?
View Single Post
#
9
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Deleting rows messes up Named Ranges--How can this be fixed?
'=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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett