i have a range from 40 rows and open no. of columns in excell i need vb program that performs the following 1- read A5 2- if A5 has value , program makes A5 red color and then go to A6 and make same action 3- if A5 is empty , program goes to A6 and read A6 value make same action 4- repeat until A45 5- go to column 2 starting from B5 and repeat the same steps 6- program stops at last empty column