View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William Poh Ben William Poh Ben is offline
external usenet poster
 
Posts: 1
Default sort column A with "strike-through" values come first


Hi EXCEL expert,

I have this problem I have been facing for a long time at work not abl
to sort the data in column A in order to have the cells containing th
"strike-through" values in column A appear first, follow by the value
without the "strike-through".

My column A consists of Part Numbers and the strike-through applies t
all letters/numbers in the cell, and not only certain letters/numbers.

Appreciate very much if someone can help me with a VBA code to solv
this problem

Thanks in advance

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com