View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kennedy kennedy is offline
external usenet poster
 
Posts: 24
Default If statement in macro to find blank cell/value in another cell

Trying to find a macro that will allow me to find a blank cell in a column,
and if the corresponding cell is populated, then tag that cell with a certain
value.
So, if Column AG is empty, but Column AM is not, then put an * in column AG,
then loop it to look in other columns as well.
So
if AG = blank, but AM is not blank, then place * in AG,
if AN = blank, but AT is not blank, then place * in AN,
if AU = blank, but BA is not blank, then place * in AU,
if BB = blank, but BH is not blank, then place * in BB,
etc.... For a total of 15 segments