View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ALATL ALATL is offline
external usenet poster
 
Posts: 24
Default 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.