VBA for Adjusting Range of Named Area?
Wonder how to use VBA to automatically adjust a range name. The variable would depend on how many rows of contiguous blank cells are in a column. (The number of rows would change depending on what cells are filled in by the user (usually numbers), and I need the range name to automatically adjust to the number of blank rows. Also, I can't insert or delete rows, which would make it easy and obvious.)
Thanks! |
All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com