Creating dymnamic named ranges
Hi:
After a lot of digging, I found what I needed was a code set that looked like this:
Range("a2").Select
Selection.End(xlDown).Select
IROW = ActiveCell.Row
ICOLUMN = ActiveCell.Column
Cells(IROW, ICOLUMN).Select
'name the range transferdata
Cells(IROW, ICOLUMN).Name = "TRANSFERDATA"
This could help others with the same problem.
Regards
John Baker
John Baker wrote:
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
|