Delete last filled row (coumns A to H)

Hello All,

I use a macro to copy some data from a .csv file. The data is copied to columns A to H (starting from row 31), the number of rows filled depends on the particular case and is not fixed. The first column gets filled with the serial numbers.

the problem is that in the last row cells of columns B to H contain three dashes (---) .

I have written a simple code that finds the last filled cells in column A. After having found this row, I would like to clear the cells or delete them. the below mentioned simple code does finds the last filled row but I am not able to find a command to delete or clear the cells of this row. Can somebody please help !!


I know there are many more efficient way of doing this but still if anyone can complete this code, i'll be glad

Thanks...

Please Login or Register  to view this content.

No need to loop through & test each cell

Try this macro

Please Login or Register  to view this content.

arora

Once you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save