Z
zyx777
I have a worksheet in which the macro reformats the data . Original
worksheet has 600 cells and after reformatting the data it had only less
than 500 cells with data. I Save this worksheet as CSV file but it saves all
600 cells. Is there a way that I can only save cells with data in it ?
Here is what I use to save the Worksheet:
ActiveWorkbook.SaveAs Filename:=C:\Test.csv,
FileFormat:=xlCSV, CreateBackup:= false
worksheet has 600 cells and after reformatting the data it had only less
than 500 cells with data. I Save this worksheet as CSV file but it saves all
600 cells. Is there a way that I can only save cells with data in it ?
Here is what I use to save the Worksheet:
ActiveWorkbook.SaveAs Filename:=C:\Test.csv,
FileFormat:=xlCSV, CreateBackup:= false