Thanks for that
The code I posted is used to create new rows and copy formulas. It doesn't necessarily need to be there.
What I'm trying to achieve is that a user will be able to insert a new row with a new set of option buttons that are grouped separately from the existing ones with there own set of linked cells.
The reason I was using the code above was because I had a friend who said he could adapt it to do what I wanted, he couldn't.
I only have one worksheet so there is no need to replicate it across sheets, and even the function to add more than one row at once isn't essential. The most important feature is the ability to operate a new set of option buttons independently with linked cells for each row that's created.
Have attached the Spreadsheet for reference.
Sorry about not using code tags, will do in future![]()
Bookmarks