Thread: Macro to Convert Value to Number, Sort, then Delete
View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
Wouter HM Wouter HM is offline
external usenet poster
  
Posts: 99
Default Macro to Convert Value to Number, Sort, then Delete
Hi Dan,

To make it even beter try this:

While UCase(ActiveCell.Text) < "DELETE"

If you change the formula in the A column to lower or mixes case the
macro will still work.

Wouter
Reply With QuoteReply With Quote