in reply to Re: Excel’s Select and Activate considered harmful
in thread Excel’s Select and Activate considered harmful

Create your own object and assign to that. To give an example, instead of

$sht->Range("A1")->Select;
use
my $rng = $sht->Range("A1");
Then, rather than Selection->, use $rng->. Obviously, it's better to use a descriptive name rather than $rng.

Regards,

John Davies