Return range of cells in column having data where, ignoring header cell and assumes no blank in that column.
Used a lot replacing an old buggy method in other people's work ...
Set Rr = Range([c_Test_Pol], [c_Test_Pol].End(xlDown))
Edit 2025-05-11: Fixing Activesheet name issue
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Boldcodes.com
Linkedin Login
ColumnName, Optional StartingRow = 2, Optional Shee = "Active", Optional WB = "This"
Views 279
Downloads 98
CodeID
DB ID
Codes Required 0
Similar codes
Recent 4 by ANmarAmdeen 4
Random Codes 4