Checkbox Link

Am having a bit of a problem. The worksheet we use contains columns A through AB. Some columns contain the formulas needed for processing the information that is input and these are summed at the bottom of the columns. Columns B.C & D contain a checkbox and each of these checkboxes when checked (true) activate a specific column for a calculation. The check boxes beging on row 3. The linked column for each checkbox is in their respective row at columns Z, AA and AB which is used by other formulas to test for the state of the checkbox. Periodically, the number of rows with the same layout and formulas has to be increased to accomodate a larger amount of data input and I need to add a new row below the last existing row (just ahead of the row which holds the summed column data). I have been trying to find a VBA solution that after clicking a button on the worksheet, a new row is added with all of the relevant formulas and link the 3 new checkboxes to their respective columns Z, AA and AB. The button with the attached code is working but am stuck on getting the linked cell to work. This is the code that I am using thus far:

Please Login or Register  to view this content.

For some reason there was some hidden things in my worksheet in that one section counts the number of checkboxes which are 60 by default. The count being returned was 100 and once I deleted out several hundred empty rows (wasn't sure how far to go), the script functioned fine. Thanks for the input.