Re: Macro or IF statement??? HELP!

From: chris (anonymous_at_discussions.microsoft.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 05:26:02 -0700

Actually she said: "these are one's that have no deatils in the "Bank" "Sort
 Code" "Account" columns."
Which means that those 3 columns are blank, but there could possibly be other columns., also your not sure if a record may have data in one and not in another but yet still be valid. OPs don't always give the full picture so i'm not quick to give them quick easy solutions that could wipe out their data.

     
     ----- Norman Jones wrote: -----
     
     Hi Chris,
     
     Julia said:
     
      "All's well apart from some of the accounts I dont need -
           these are one's that have no deatils in the "Bank" "Sort"
     
     I stand by my post.
     
     ---
     Regards,
     Norman
     
     "chris" <anonymous@discussions.microsoft.com> wrote in message
     news:A0086B2C-9297-4D21-8C76-D7113A5A52D8@microsoft.com...
> This is a wholesale approach: if your just looking for any blank cell,
     but if you have intermittent blank cells within your range, but are still
     part of a valid account record they will be deleted too. So be cautious how
     you use this. If you need to have a set of criteria before you delete a row
     more sophisticated code is required.
> ----- Norman Jones wrote: -----
>> Hi Julia,
>> You can do this manually:
>> F5 key | Special | Blanks | ok
> Edit | Delete | Entire Row | ok
>> If you need a programming solution, try:
>> Sub DelNoSortCodes()
> Dim Rng As Range
>> Set Rng = Range("B2:B1000") ' <-- Adjust to your
> SortCode Range
>> On Error Resume Next
> Rng.SpecialCells(xlBlanks).EntireRow.Delete
> On Error GoTo 0
> End Sub
>> ---
> regards,
> Norman
>>> "Julia Easter" <egglett@hotmail.com> wrote in message
> news:1289b01c4430e$bbab5ef0$a301280a@phx.gbl...
>> Hi - I've got a stack of customer data that's been
>> extracted from a database in CSV format and then opened in
>> Excel
>>> All's well apart from some of the accounts I dont need -
>> these are one's that have no deatils in the "Bank" "Sort
>> Code" "Account" columns.
>>> My question is how do I go about getting Excel to look at
>> the blanks and automatically Delete them?
>>> So far my little knowledge allowed me to make the
>> following if statement but it only tells me to
>> physically "DELETE" non-bank customers... I want to know
>> how I get to tell Excel to actually search for bloanks
>> then delete.... if that makes sence!!
>>> HELP
>> Ta
>> Julia
>>>