Thanks this is Great

I wondered if your code could be adapted to work in a userform
You have shown me that check boxes are not needed for the holes unless multiple hole analysis is required so a combobox is all that is needed
thanks again for your help
James