I have 14 rows times’ 31 columns and in each cell there is a check box. There is a control button with an assigned macro in front of every row that allows you to check all the boxes in the entire row. There is also one control button that clears all checked boxes and make them unchecked. All worked fine until I inserted four rows also with checkboxes, but without any macros. Since then every time I want to use control button with macro to check entire row, VBA pop up window appears:
Run-time error `1004`:
Method `Range` of object`_Global` failed
If then I click “End” the macro operation executes as normal and pop up disappears
And if I click “Debug” VBA opens and there is line yellow marked: “Set row_num = Range(cb.LinkedCell)”
Please help me
Bookmarks