Reading in CSV files

Hi there. I'm using the following code to read in any number of CSV files into a single worksheet and concatenating them together

Please Login or Register  to view this content.

It works fine the first time I run it after opening the workbook (I've got 12 rows of data across 3 CSVs) 12 rows are pasted and 1 blank row at the beginning.

The second time I run it it pastes into the worksheet starting from row 14, and then 27 the third time etc.

Does anyone know a way I can make sure it always pastes starting from row 1?

Thanks in advance.

Hi FactCheckinCuz. Welcome to the forum.

Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to edit that post above and put code tags around that code you used. (Like I did below...)

Here's how I would structure your macro to remove the need to switch back and forth between sheets to copy the data in, and also how to start at row1 and move down.

Please Login or Register  to view this content.

I've highlighted in red the parts that relate directly to your question about the rows.