DYNAMIC RANGES
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. |
DYNAMIC RANGES
|
DYNAMIC RANGES
|
DYNAMIC RANGES
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. |
All times are GMT +1. The time now is 10:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com