View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Workbook Workbook is offline
external usenet poster
 
Posts: 121
Default Delete Duplicate Header Macro

Row A1:L1 contain the following contents.
A1 = OT
B1 = ON
C1 = PT
D1 = M
E1 = SN
F1 = AD&T
H1 = RQ
I1 = PN
J1 = D
K1 = P
L1 = SL
I would like to search A2:L100 for these contents and every time I find them
in a row to have that row be deleted. Any input is greatly appreciated.