<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Select method of Range class failed in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Select-method-of-Range-class-failed/m-p/89340#M39741</link>
    <description>Hi,

I have to extract two excel column from two different workbooks into Blueprism. So&amp;nbsp;while using "Get Worksheet Range as Collection" action for extracting data, I am getting the following error "Internal : Could not execute code stage because exception thrown by code stage: Select method of Range class failed".&amp;nbsp;I&amp;nbsp;have used the above action twice and the problem appears after the first range is extracted. I have ensured that all the data entered into the action are correct.

Could anyone please help me to resolve this issue?

Thanks in advance.</description>
    <pubDate>Thu, 15 Feb 2018 20:04:00 GMT</pubDate>
    <dc:creator>RakeshDey</dc:creator>
    <dc:date>2018-02-15T20:04:00Z</dc:date>
    <item>
      <title>Select method of Range class failed</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Select-method-of-Range-class-failed/m-p/89340#M39741</link>
      <description>Hi,

I have to extract two excel column from two different workbooks into Blueprism. So&amp;nbsp;while using "Get Worksheet Range as Collection" action for extracting data, I am getting the following error "Internal : Could not execute code stage because exception thrown by code stage: Select method of Range class failed".&amp;nbsp;I&amp;nbsp;have used the above action twice and the problem appears after the first range is extracted. I have ensured that all the data entered into the action are correct.

Could anyone please help me to resolve this issue?

Thanks in advance.</description>
      <pubDate>Thu, 15 Feb 2018 20:04:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Select-method-of-Range-class-failed/m-p/89340#M39741</guid>
      <dc:creator>RakeshDey</dc:creator>
      <dc:date>2018-02-15T20:04:00Z</dc:date>
    </item>
    <item>
      <title>I have used that action a…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Select-method-of-Range-class-failed/m-p/89341#M39742</link>
      <description>I have used that action a number of times with no problems so I am guessing there is something wrong either with your range syntax or the range you are trying to select itself?</description>
      <pubDate>Fri, 16 Feb 2018 14:13:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Select-method-of-Range-class-failed/m-p/89341#M39742</guid>
      <dc:creator>Denis__Dennehy</dc:creator>
      <dc:date>2018-02-16T14:13:00Z</dc:date>
    </item>
    <item>
      <title>Thanks Dennis for your quick…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Select-method-of-Range-class-failed/m-p/89342#M39743</link>
      <description>Thanks Dennis for your quick reply.
I have found a work around by creating different instance for different workbooks and it's working fine.</description>
      <pubDate>Fri, 16 Feb 2018 20:15:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Select-method-of-Range-class-failed/m-p/89342#M39743</guid>
      <dc:creator>RakeshDey</dc:creator>
      <dc:date>2018-02-16T20:15:00Z</dc:date>
    </item>
  </channel>
</rss>

