+ Reply to Thread
Results 1 to 2 of 2

Error message - 'These columns are out of bounds'

  1. #1
    Registered User
    Join Date
    07-22-2019
    Location
    San Jose
    MS-Off Ver
    2010
    Posts
    1

    Error message - 'These columns are out of bounds'

    Hi,

    I am trying to write a script that allows me to filter the dataset by values in a particular column (here, 'AttendeeStatus') and copy-paste the filtered values into a new worksheet in the same workbook (here, 'Attendees'). The script does the job filtering the data but throws up an error - 'These columns are out of bounds' - when trying to paste the filtered values into the new worksheet. Here's my code:

    Please Login or Register  to view this content.
    Any pointers would be appreciated - thanks!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2412 (Windows 11 24H2 64-bit)
    Posts
    88,707

    Re: Error message - 'These columns are out of bounds'

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. As you are new here I have done it for you this time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Vlookup error ["VLOOKUP evaluates to an out of bounds range" in Google Sheets]
    By Jietoh in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 03-23-2017, 01:35 PM
  2. Download Outlook mail to excel - runtime error, array index out of bounds
    By Jarryd12 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2017, 05:04 PM
  3. Calling Webservice: Error (Index was outside the bounds of the array)
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2015, 12:45 AM
  4. [SOLVED] "The index into the specified collection is out of bounds" error
    By kundterra in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-05-2014, 12:32 PM
  5. Create ERROR message when two columns in the same row are used
    By linebacker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2014, 12:06 PM
  6. Need Help in Sorting Individual columns by cell color, receive error message.
    By TonyM-2010 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2014, 10:50 AM
  7. Error message when hiding columns
    By valenj in forum Excel General
    Replies: 1
    Last Post: 06-06-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1