Search results

I had tried it before and it was giving me an error, I used the long form Range:="Sheet 1" and it worked, but it brought me back to another issue that I had while trying different ways to do it, if the sheet name has a space, it will change the space with an underscore. Try Range:="Sheet 1"...

Yes, I know, the problem still exists now, 2022 and you cannot specify the sheet name, I was doing research to get solutions, I found this thread, I came up with this solution that worked for me and I figured I would share it for others, that's all

Actually the answer above it's incorrect, as specified in MS documentation Range :This argument applies only to importing. Leave this argument blank to import the entire spreadsheet. When you export to a spreadsheet, you must leave this argument blank. If you enter a range, the export will fail...