Results 1 to 7 of 7

Thread: [RESOLVED] Fastest way to clear cells based on cel length

Threaded View

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431

    Resolved [RESOLVED] Fastest way to clear cells based on cel length

    I have a huge amount of data (8000 rows x 100 columns). Most cells have a length of 3, many others are blank and some have lengths of 1 or 2. I need to clear cells if the cell length isn't 3. I know of course that I can do this
    Code:
    Dim cel As Range
    For Each cel In MyRange
        If Len(cel) = 2 Or Len(cel) = 1 Then
            cel = ""
        End If
    Next
    but I'm looking for a faster way. Any ideas?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width