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.