How to fix Run time error '1004' Method 'Range' of Object '_Global' failed when trying to generate vba upload file

Question

Answer 1

First, when you get the error, click on Debug to find the line of macro code that generated the error.

Then show us that line plus enough preceding lines to establish some context. It would also help if yu show us the declarations for the variable in question.