Detect the last filled row in column a and delete all rows after it

hi all

i need your help plz

i need a macro to detect the last filled row in column A, then to delete all rows starting from the next row.

thanks.

hi

i have for example a big sheet; the last filled cell in column A is: A1500.

the macro will detect that the last filled cell in column A (A1500) then will delete all rows starting from A1501 to the end of the sheet.

thanks

any help plz?

Do you have any data from A1500 onwards? If yes, your last data would not be A1500
It may be possible if you have a text in A1500, so that we can use it to define the last data

ok i got it

the following code will detect the last cell filled in column A then will delete 1000 rows starting from that cell +1

Please Login or Register  to view this content.

thanks

Please Login or Register  to view this content.

This is hard coding. Why 1000?, not 500.

all urs, change it based on ur requirement