Hello. This is my first time posting for a VB question. What I am looking to do is create a code that will scan a designated range and remove any blank rows. These blank rows are a result of a formula that I created from an =IF statement leaving a " " if it was false. Is there a way to remove these blank rows and possibly even shift the cells up?

A B C D E
1 ! ! ! ! !
2
3@ @ @ @ @
4# # # # #
5

In this example, numbers were just replaced with random symbols, but what I would like to have happen is have rows 2 and 5 removed and have the data shifted up.

Is this possible? Thank you.