Select method of Range class failed

[Dave Angel]

On 12/23/2014 06:04 AM, Jaydeep Patil wrote:
> Hi all,
>
> I have developed python code which copy & paste data from one excel sheet to another excel sheet. I have compiled code both for 32 bit & 64 bit. It is working fine on 64 bit machine. But on 32 bit, it is giving below error.
>
> rng.Select()
> "Select method of Range class failed"
>
> Just to know you, I am continuously copying data from one excel sheet to another sheet.
>

There are a larg number of posts on the internet where people have the 
same error message in VBA.  it's probably a fundamental problem in the 
Excel logic.  One solution frequently posted is to avoid doing a select; 
  apparently it's seldom actually necessary:

http://www.mrexcel.com/forum/excel-questions/585856-runtime-error-1004-select-method-range-class-failed.html


-- 
DaveA