|No such thing as a small change|
Re^4: Inserting copied rows at another position in Excelby HelenCr (Monk)
|on Jan 12, 2013 at 14:49 UTC||Need Help??|
Thank you, Davies.
Firstly, I think I made a mistake, my last code line should go:$sht->Range($rngToTopLeft)->Insert;
instead of what I wrote.
Second, about the "EntireRow" method, since, in your code, you havemy $rngFrom = $sht->Range("A1:A9")->EntireRow;
then aren't you assured that the insertion will be entire rows?
and thirdly, can you detail what you mean by "two types of Insert"?
Many TIA - Helen