Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #82835 > unrolled thread

Select method of Range class failed

Back to article view | Back to comp.lang.python

Contents

  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

#82835 — Select method of Range class failed

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.


Regards
Jaydeep M Patil

[toc] | [next] | [standalone]

#82836

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

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web