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
use$sht->Range("A1")->Select;
Then, rather than Selection->, use $rng->. Obviously, it's better to use a descriptive name rather than $rng.my $rng = $sht->Range("A1");
Regards,
John Davies
|
|---|