View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_86_] John[_86_] is offline
external usenet poster
 
Posts: 9
Default 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