Ive created a program in Visual Basic which transfers data to a new work
book but it gets chopped short after a predetermined number and I cant find
how to change it.

Hi Col,

First up I know nothing about Visual Basic so I may be a long
way off here but I imagine that your routine would be calling
up Data Validation to do this.

So maybe look through your routine for a reference to data validation
and try playing with the settings in the routine.

Just a guess
Martin