VBA to remove blank rows from a range

[Keibri]

Hi all,


I would like whether someone can please help me with the below. I found this code which basically will select a range and delete all blank rows in a particular range (see source below):

https://officetricks.com/delete-empty-rows-in-excel/

Please Login or Register  to view this content.

I would like to modify it a bit so as to specify as well the sheet from which the rows have to be deleted. I.e. if the sheet is called "Test". The code should just delete the rows from the sheet called "Test".

Problem being that if I run the code and I the active sheet is not "Test" it is deleting the rows of that other sheet. So I would like the VBA to just delete the rows on the sheet "Test"


Can someone please help me out?

Appreciate a lot your kind help!

Thanks


Keibri

[JLGWhiz]

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Change this line:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

BSB

[Keibri]

Cheers guys!! Thanks for your help! It was awesome!