使用VBA将Excel工作表的一部分（部分）导出为CSV

I know exporting to csv has been asked about a billion times, and I've done it quite a few times, but I'm trying to figure out how to export only a portion of the sheet to csv without cycling through each row or cell and printing them individually to file. I need to maintain local formatting as one requirement.I know exporting to csv has been asked about a