I do not see any wrong with your code.
Yes, I have re-run the code a couple of times. When you run the code by pressing F8, all the data are copied, but not when I press the button. I suspect this line could be the reason.
When I change it to these lines, I do not get an error
The code sometimes might not work as there is time lag between log in and data retrieval. The data are also retrieved from the body of the table.
I do not know if you include a timer in your code will help.
Application.Wait (Now + TimeSerial(0, 0, 5))
As to the first as column underneath, this is because you are getting a text, so the code will copy the picture if there are not text, not the picture.
Bookmarks