Thanks this is almost perfect, but because the segments aren't perfect hexagons, the global padding setting in the macro doesn't give enough control.
As you can see in the screenshot, I need to reduce the padding in just the vertical axis to close up this gap as shown in the sample arrangement below.
EDIT: You can delete this, I completely glossed over your bit about the additional transform. problem solved