Creating dymnamic named ranges
John,
Try a name with a RefersTo value of something like
=Sheet1!$A$1:OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A:$ A)-1,0)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"John Baker" wrote in message
...
Hi:
I have a spreadsheet that contains a section I wish to import into Access.
Because the
amount of data (specifically the number of rows) varies, I wish to give
the range a name,
and I want to the name to refer to only those cells that contain data in
column A. I know
how to SELECT the range, BUT I do not know how to make that selected range
into a named
range, through programming.
If someone could help me with this I would much appreciate it.
Regards
John Baker
|