Struggling to import Customer Age analysis from CSV to Workbook

My objective is to import a Customer Age Analysis from A CSV file into an Excel workbook, but I am running in to two issues:

1. When I want to import the Header rows of the CSV file it completely ignores them when I want it to start importing from row10, it works fine if I start to import from row 1

Here is the code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Next lines of code.........................

2. I am also adding Tick boxes next to each column, What I also do is in the last row there is a Grand Total, Which Delete and replace it with Total Outstanding with sum formulas. I don't want the import button to add a tick box in the last row Total Outstanding


code......

Please Login or Register  to view this content.

last lines of code... Ending with a Message Box

	Col A	Col G	Col H	Col I
Row10	Customer	Balance	Total Overdue	Select y/n
Row11	Name	5000	5000	Tick box
Row 12	Total outstanding	5000	5000	Blank