clear cells below last row with a value

[Cheeseburger]

So I have a macro that enters a formula into every cell in the range, A51:N147. The formulas perform a logical test and always result in a value except when it gets to the end and then from that end point all other cells/rows below it result in "" or blank.

So for example if you run the macro the formula is entered into every cell from A51:N147, but below row 80 they might be all blank. However, even though they are blank, they are not treated as pure empty cells.

I would like a separate macro to basically find the last row in that range that has a real value, and clear the contents of all rows below it so they are truly empty cells.


Thanks for any help you can offer.

[StuCram]

Here are 2 solutions; a short specific one for your range and a more general one.

Version 1:

Please Login or Register  to view this content.

Version 2:

Please Login or Register  to view this content.

[Cheeseburger]

Perfect! Thank you so much!