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.