Issues with vba macro while creating csv files

Hello,

I am not a good programmer in VBA. I have a task to -

1. [1] Read Input sheet from xls (rows 2 to 101). Provide a button.
   [2] On Button click create 2 files. One csv and another backup files for the selected columns (column 1 and columns from 3 to 12).
   [3] Add Header and Footer for the csv files
   [4] Clear the content of the Input sheet (row 2 to 101).

As mentioned I am not good programmer so I am not able to understand what is wrong in my code. I am facing a problem - If input sheet holds 10 records then the csv file getting generated holds 10 records followed by 90 empty comma separated records.

Can experts please help me with this - Code attached? I tried to reduce the code as much as possible. There are some updates which may look odd but then they are because I tried every other option to solve the problem in my capacity.

Thanks.