I am looking to develop a macro that will allow me to select a range
of cells dynamically. I have created a mapping template that maps user
defined fields to native fields, but each file that I map has a
different number of rows of data. Rather than simply selecting a range
of cells statically, I am hoping that there is a macro out there that
will allow me to catch all data in a column by dynamically assigning my
range to include all rows of data up to the last row containing
information and no more. To add to this issue, not all intermediate
rows will contain data, but it is important that I capture all data in
the spreadsheet in my range. Any assistance will be most appreciated.

Hi,
Check this link: http://www.beyondtechnology.com/geeks007.shtml

Hi,
Check this link: http://www.beyondtechnology.com/geeks007.shtml

debra has some instructions on her page

http://www.contextures.com/xlNames01.html

--


Gary


wrote in message
ups.com...


I am looking to develop a macro that will allow me to select a range
of cells dynamically. I have created a mapping template that maps user
defined fields to native fields, but each file that I map has a
different number of rows of data. Rather than simply selecting a range
of cells statically, I am hoping that there is a macro out there that
will allow me to catch all data in a column by dynamically assigning my
range to include all rows of data up to the last row containing
information and no more. To add to this issue, not all intermediate
rows will contain data, but it is important that I capture all data in
the spreadsheet in my range. Any assistance will be most appreciated.