Unable to get the Text property of the WorksheetFunction class
I have a spreadsheet that I'm exporting data to a text file from. It
reads each cell and prints them out in a specific way in the text
file. When the value of one of the cells gets a couple lines worth of
data, it give the error listed in the subject. The variable is
defined as a string. I copy and paste the content into notepad but do
not see any issues with carriage return or anything so not sure what's
going on here. If I shorten the length of the cell it works fine.
Anyone know what's going on here?
Thanks.
JR
|