Re: Range property of a Cell is empty and cause script crash

From: Klaus Linke (info_at_fotosatz-kaufmann.de)
Date: 12/21/04


Date: Tue, 21 Dec 2004 14:23:32 +0100

Hi Nicolas,

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
can't.
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
perhaps).

Regards,
Klaus



Relevant Pages