In reference to this thread, I want to input data into a UserForm text box, have this pasted into the worksheet, then arrange the data (which is pasted into a single cell) into rows (which will be used by a macro).
I am having a problem with the character limits. I believe that when the UserForm pastes the data into the cell, it is being cut off after 32K characters or so. Is there any way around this? Can I either increase the character limit of the cell, or maybe have the UserForm paste differently? Or do I just have to limit how much data I enter into the UserForm?
Thanks!
EDIT: I am currently using Excel 2007.
Bookmarks