Limit the dynamic range of find and replace

Hello,

I'd like to Find and replace blank cells in columns O and P, with the word "BLANK CELL" but only = to lowest data row in col D and then stop.

Can this be done?

thanks

First key question is whether of course they're true blanks or are in fact formula Nulls ?

Assuming true blanks you could perhaps use:

Please Login or Register  to view this content.