Thanks DaddyLongLegs

But will that also apply to B2:B11 or Z2:Z11?

Will the records for the B column the C column the Z column be affected the same?

Thanks.