How do I remove text limit on a cell

[Guest]

I’ve 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 can’t find
how to change it.

 

[MartinW]

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