Results 1 to 10 of 10

Delete whole row if column F meets a condition untill last row of data

Threaded View

  1. #4
    Registered User
    Join Date
    04-09-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Delete whole row if column F meets a condition untill last row of data

    Hi tom , tried your codes , good news is that there is not error msg or anything , however bad news is that the row supposingly to be deleted off is still there haha !

    just to provide more information , this blank cells are resulted in one of my previous codes which i split a long string of message ( that in the message there is no spacing in between words an example of a message like : Hicanihelpuyoutodayis12-03-2012)

    i had use

    'splits Text active cell using ALT+10 char as separator
    Application.ScreenUpdating = False
    Dim splitVals As Variant
    Dim totalVals As Long
    'split every row untill is empty
    Worksheets("sheet2").Activate
    Range("F2").Select
    Do Until IsEmpty(ActiveCell.Value)
    splitVals = Split(ActiveCell.Value, Chr(13))
    totalVals = UBound(splitVals)
    Range(Cells(ActiveCell.Row, ActiveCell.Column + 1), Cells(ActiveCell.Row, ActiveCell.Column + 1 + totalVals)).Value = splitVals
    ActiveCell.Offset(1, 0).Select
    Loop

    so there are empty cells between words ( " hi " , "" , "can" , "" , "help" ...... )

    Hope you understand what i am saying =S i not sure how to relate the problem well but this is my try of explaining my problem =S
    Last edited by andywsw; 04-12-2012 at 03:43 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1