Can you explain how dynamic?

Will it always end on I25 or will right most column change? What are the ranges that would be valid ActiveCell to trigger this event?

EDIT: Oh and should it be only on one worksheet this should happen? Or all sheets in a workbook?