Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Copy Paste a variable number of rows
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...- BENC
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - Testing if a cell is in a Named range
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...- BENC
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
