Running "Refresh Selected" using VBA

Discussion in 'General Questions' started by Parkd2, Jan 16, 2020.

Running "Refresh Selected" using VBA

  1. Parkd2

    Parkd2 New Member

    Joined:
    Feb 11, 2016
    Messages:
    12
    Likes Received:
    0
    Is there a way to run "Refresh Selected" from within a macro or using VBA? I have written a VBA script to select the contents of the active row but I have to then manually select Refresh Selected. I'd like to have the script run it.

    This is a work around the problem of >1000 cell error when trying to update a row (or column) of data by selecting the entire row (or column). Instead I have to take the time to manually select the beginning and end of the data.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,157
    Likes Received:
    11
    Sorry for the delay, if you are using the latest version this message should go away.
     
  3. Parkd2

    Parkd2 New Member

    Joined:
    Feb 11, 2016
    Messages:
    12
    Likes Received:
    0
    I am using version 9.0.6.0 and I still get the error when I select an entire row and select Refresh Selected. There are less than 25 calls to Market XLS in the row but I exceed the 1000 cell limit.
     

Share This Page