+ Reply to Thread
Results 1 to 11 of 11

Location to print array not find error 9 out of range

  1. #1
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    241

    Location to print array not find error 9 out of range

    Hi,

    I have a sheet called Bittrex.
    The macro 'GetMyBittrexdata' go get the balances table by an api.

    Now I want to get by api another table 'getMyOpenOrders'
    if possible on sheet Bittrex2

    If I run the macro with this api it perfectly get the table of my openorders, BUT

    it overwrite my balance table on the first sheet.
    IF I change the sheetname in the 2nd macro from Bittrex to bittrex2, I get an error
    9 ' out of range'

    I am not skilled enough I think to understand/find where the macro determine WHERE the array has to come on the sheet.

    Now its at first sheet cell B12, but NOWHERE I can find the reference,

    Anybody know where it is, What to change pls ?

    Thank you
    Chris
    Attached Files Attached Files

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Location to print array not find error 9 out of range

    My best guess would be that you have to create a table on sheet Bittrex2 (name it Tbl_Bittrex_Ledgers2) and change
    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    241

    Re: Location to print array not find error 9 out of range

    Hi Bakerman

    Thank you for your suggestion, but the error still there :-(
    sorry

    Chris

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Location to print array not find error 9 out of range

    Did you also create these ones on your second sheet (with different names ofcourse)

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    241

    Re: Location to print array not find error 9 out of range

    my second sheet is empty

    what you mean different names ?

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Location to print array not find error 9 out of range

    You'll have to do 3 things.

    1. Create a table called Tbl_Bittrex_Ledgers2
    2. Create NamedRange apikey_bittrex2
    3. Create NamedRange secretkey_bittrex2

    then put this in your code.

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    241

    Re: Location to print array not find error 9 out of range

    ok thanks I try
    create a table, is just do something in the macro ? or also prepare in sheet bittrex2
    can I just copy paste ?

  8. #8
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Location to print array not find error 9 out of range

    All the above have to be done in sheet2.

  9. #9
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    241

    Re: Location to print array not find error 9 out of range

    I DID IT

    thanks to you my problem is solved
    thank so much for helping and teaching me !
    Chris
    Last edited by incobart; 11-27-2017 at 02:44 AM.

  10. #10
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    241

    Re: Location to print array not find error 9 out of range

    will put solved now

  11. #11
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Location to print array not find error 9 out of range

    You're welcome and thanks for rep+.

+ 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. Creating an Array from range, no duplicates, filtered by location
    By gottnoskill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-13-2015, 10:14 AM
  2. Find Value within Range & use Formula relative to that Location
    By Circ Lab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2015, 05:36 PM
  3. [SOLVED] Populate one array from another array and print new array as a range
    By Kaden265 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2014, 07:52 AM
  4. Find Print Range and Print invoices from 250 tabs in Excel
    By Mr5holesinone in forum Excel General
    Replies: 4
    Last Post: 02-24-2014, 08:19 PM
  5. [SOLVED] Add Range to Array find Array value and Paste back to Range
    By Foreverlearning in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-28-2012, 05:45 PM
  6. Replies: 5
    Last Post: 10-19-2011, 10:18 AM
  7. Array to Find Workbook, Print Sheets from a List
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-16-2010, 10:11 AM

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