Dynamic Ranges of Rows Cont'd

[NatalieEC]

Hello Again,

Recently, member Millz just helped me update code based on a dynamic range of cells, which worked! I want to drop a csv file into one sheet, and copy the data to another sheet. However, if I drop a new csv file in, and there are fewer rows, the old rows aren't deleted. For example, if my first set of data had 10 rows, and the new has 8, the extra two rows are still there. How do I deal with this?

[code]
With Sheets("Raw Data")
.Range("A10", .Range("A" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("A12")
.Range("B11", .Range("B" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("B12")
.Range("E11", .Range("E" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("C12")
.Range("F11", .Range("F" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("D12")
.Range("H11", .Range("H" & Rows.Count).End(xlUp)).Copy ActiveSheet.Range("E12")
End With
[\code]

[MarvinP]

To remove all the existing data, before "dropping in a new csv" file. Try

Cells.ClearContents

[NatalieEC]

Thank you! I initially was using DeleteColumn, bad idea, ruined everyt