Re: Range property of a Cell is empty and cause script crash
From: Klaus Linke (info_at_fotosatz-kaufmann.de)
Date: Tue, 21 Dec 2004 14:23:32 +0100
I don't know anything about Perl, either...
Cell.Range.Text has the end-of-cell marker = Chr(13) &Chr(7) at the end.
Perhaps the code falls over because Perl tries to delete/overwrite that, and
VBA obviously has some work-arounds to avoid this kind of problem.
You could try to change only the text up to the last two characters (using Mid