View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SharonInGa SharonInGa is offline
external usenet poster
 
Posts: 1
Default Delete Hidden Data

We sometimes get imported information with "noise" data.
How can I programatically delete the rows that appear
empty? Right now, I click on CTRL END and delete the
columns from the CTRL END point to the worksheeet with
info in it.


A B C D E F
1 Smith Atl GA
2 Jones Bir AL
3 Rose Oak CA CTR END

Programatically delete d1:f3