I have a spreadsheet that has over 800 check boxes split into two columns. One set of check boxes is in column P and one set is in column R. I would like to create a button that will just either check all the checkboxes in column P or uncheck all the checkboxes in column P without affecting the checkboxes in column R. I can do this for the entire sheet, but am having trouble just limiting it to column P. I know just enough about VBA to be dangerous, so any help would be greatly appreciated. Currently these are all forms control checkboxes but I could change them to ActiveX checkboxes if needed.