Try using the CurrentRegion property. If you know the address of a cell in the data, CurrentRegion will find all the cells that adjoin it (try Shift-Ctrl-8 in a spreadsheet to see the current region). You can then use rows.count to get the number of rows in the current region, for copying your...
I need to do some validations on a spreadsheet, and am using different named ranges for the data input areas.
My problem is when a user enters data, how do i identify which named range the cell is in without trawling through all the range names and comparing the addresses with the current cell...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.