Re: Select method of Range class failed

Date	2014-12-23 07:09 -0500
From	Dave Angel <d@davea.name>
Subject	Re: Select method of Range class failed
References	<d729cba2-943f-46e2-a355-b078441c70e4@googlegroups.com>
Newsgroups	comp.lang.python
Message-ID	<mailman.17152.1419336569.18130.python-list@python.org> (permalink)

Show all headers | View raw

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

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Select method of Range class failed Jaydeep Patil <patil.jay2009@gmail.com> - 2014-12-23 03:04 -0800
  Re: Select method of Range class failed Dave Angel <d@davea.name> - 2014-12-23 07:09 -0500

csiph-web