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:
    11
    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.
     

Share This Page