Hello,

I would like to create a macro to search Column A for any entries & if
there is no data in Column A, insert the words "No Data" into Cell A2.
If there is data, then sort the data descending. I can sort the data,
but am not sure how to search the column ??

Thanks,

Oreg


--
Oreg
------------------------------------------------------------------------
Oreg's Profile: http://www.excelforum.com/member.php...fo&userid=9195
View this thread: http://www.excelforum.com/showthread...hreadid=381181