Hi thanks for your reply.

Yep finding it very useful. I'm actually using latex and vba code to come up with the the questions and answers (I have a fair few rules to enforce, ie. integer answers etc)

I was going to use the microsoft (unsupported) mathtype thing but that looked like a real pain and I already knew latex.

Putting everything on the the worksheet (typesetting) was very easy with ActiveSheet.Shapes.

As long as I ran it sequentially (ie. two columns of say 10 rows each) I could just pick them up with ActiveSheet.Shapes.Item() and place them on to the the print area perfectly with

For s = 1 To (ActiveSheet.Shapes.Count / 2)

ActiveSheet.Shapes(s).Top = Range("H" & s).Top

ActiveSheet.Shapes(s).Left = Range("H" & s).Left

Next s

For s = (ActiveSheet.Shapes.Count / 2) + 1 to ActiveSheet.Shapes.Count

ActiveSheet.Shapes(s).Top = Range("I" & s).Top

ActiveSheet.Shapes(s).Left = Range("I" & s).Left

Next s

I've been looking for years for some decent worksheet creation tools and had given up and decided to create my own.