Select Row 1 through "X" and Delete

Hi there,

What your code does is, it takes everything till the last row, regardless of empty rows in between the data set.

You want to delete everything that is above the first empty row?

Try this:

Please Login or Register  to view this content.

Thank you for your fast reply. The minute I hit post I found an older post (which I had searched for a while) that showed me this:

Please Login or Register  to view this content.

Seems to do the trick.

Now what I am having a hard time doing is selecting cells "S1" : last active column in row 1, using row 2 as my reference. I have tried the following code, but it errors out:

Please Login or Register  to view this content.

Ideas?

Thanks,
Matt

Why are you using A2 if you're looking for the last used column? To look for the last active column in row 1, which is S1, you could do this:

Please Login or Register  to view this content.

Thanks again for the quick reply.

However, I am not sure I understand how to integrate your code into mine. I need to select cells S1 through the last active column (but there will not be any data in row 1 from S forward. However, row 2 has data.

Does that make sense??

Thanks,
Matt