How do I remove text limit on a cell

C

ColCam

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.
 
M

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
 
Top