Thread: deleting cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] lijia137@gmail.com is offline
external usenet poster
 
Posts: 6
Default deleting cells

I have a workbook that i need to delete some cells automatically after
sorting. The rule is to use one specific column (say column O) as
reference, i.e. values<100 in this column, together with things in the
same rows should be deleted, basically it's to delete a range of data?
how should i write it? Thanks a ton!