delete rows

[james potter]

I working on a little project but can not find a solution for a small problem.
I tried but did not succeed. So could anyone assist my?

I have a table with data, for instance, from A1 to F9, this range can change in size due to data import. The last two lines start with their data in column B. I want those rows to be deleted if they have data in column B and not in column A. I know how to code to go to the last edit cell in column A and one down. But I do not know how to make the row variabel in my code. Was the code for this part?

An other project I am working is almost the same but not with the B column part. I just want to go to the last edit cell in column A and every row under that cell can be deleted. Was it the code for this part?

Thanks sofar

 

[Andrew Poulsom]

The Range object's EntireRow property will return the entire row for that Range. Then you can use the Delete method. Example:

Range("A1").End(xlDown).Offset(1, 0).EntireRow.Delete

 

[james potter]

Thanks for your effort. This was just what I need. A push in the right direction. It's working now.