Column1Range

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

CodeFunctionName What is this?

Public

Tested

Original Work

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 Bold.codes

Linkedin Login

Parameters

ColumnName, Optional StartingRow = 2, Optional Shee = "Active", Optional WB = "This"

Permanenet link

Statistics

Views 279

Downloads 98

IDs

CodeID
DB ID

Requirements

Codes Required 0

Similar Codes

Similar codes

By Developer

Recent 4 by ANmarAmdeen 4

Random Codes

Random Codes 4