Enter "Empty" if cell is blank within a variable range
As simple as this sounds, I can't seem to make this work. I am looking for
code for the following:
I would like to enter the word "Empty" into a cell if the cell is blank. The
range can be variable. The only columns that contain an empty cell are
columns B or C which can have any number of rows.
I appreciate any suggestions.
Best.
|