Need defined parameters on macro that combines workbooks

I have this macro that combines a series of workbooks in a filepath I tell it to look it. The problem with the macro is that when it pastes all the workbooks into the raw data workbook it erases all information below row one. I would like to adjust the macro so that it just copies and pastes into the column range I define, in other words, copy columns A:BJ, rows 7:till it finds no data in column A

here is the code:

Please Login or Register  to view this content.

It doesn't look like it deletes anything from the 'source' files. Is the problem that it clears the target sheet (Sheets("Raw Data")) prior to importing the new data?

If so, just delete or comment out the line wsDest.UsedRange.Offset(1).Clear.

Dion

the problem isn't necessarily that it clears, it's the range that it clears which is everything below row 1, i still need it to clear everything below row row but only in between columns A:BJ and I'm not figuring out how to set that range.

Replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

still seems to be clearing column BK and I'd fix it myself but I totally don't understand this particular code. I get so lost when it's not clear cut rows and columns.