Unlocking numerous check boxes in a single column, variable column length

So I have this macro that works to check or uncheck all the checkboxes in a single column cells o23:o522 on a worksheet named "PayAdj".
The macro runs when I select or unselect the check box at the top of the column "Check Box 32433".

I need the "522" value in the current range reference (o23:o522) value to be dependent on a value that gets calculated on the "PayAdj" worksheet in cell BY14, also named as "lastrowdata"
For example if BY14 held the value 26, the range would be o23:o26.

I have been struggling with this little item for hours. I would greatly appreciate any help on this.

Please Login or Register  to view this content.

That 2nd option also worked. Thanks.