John,

When you say 'auto increment across the row' are you actually putting
incremental numbers into the cells or are are you checking the value of
every cell or are you only interested in the value in X?

Is the checkbox in a userform or on the sheet?

A little more detail about what your trying to do, and maybe why, would
be useful.

Kind regards,
NickH