in reply to Re: Excel’s Select and Activate considered harmful
in thread Excel’s Select and Activate considered harmful
Usually in the code that I've written, I'm interested in reading from or writing to a cell and I don't need or want to keep a reference around for that cell. In my case, I just skip the selection step altogether with code like:
my $value = $sht->Range("A1")->{Value};or
$sht->Range("A1")->{Value} = $value;Just tossing out a suggestion (hopefully a correct and useful one) about how to avoid using Select.
|
|---|