+ Reply to Thread
Results 1 to 13 of 13

Removing blanks where blanks show blank but are code to show blank.

Hybrid View

markDuffy Removing blanks where blanks... 11-07-2013, 09:09 AM
mehmetcik Re: Removing blanks where... 11-07-2013, 10:31 AM
markDuffy Re: Removing blanks where... 11-07-2013, 12:17 PM
mehmetcik Re: Removing blanks where... 11-07-2013, 12:29 PM
ragulduy Re: Removing blanks where... 11-07-2013, 10:33 AM
sktneer Re: Removing blanks where... 11-07-2013, 11:09 AM
markDuffy Re: Removing blanks where... 11-07-2013, 12:16 PM
sktneer Re: Removing blanks where... 11-07-2013, 12:46 PM
ragulduy Re: Removing blanks where... 11-07-2013, 12:22 PM
markDuffy Re: Removing blanks where... 11-07-2013, 01:15 PM
markDuffy Re: Removing blanks where... 11-07-2013, 01:11 PM
sktneer Re: Removing blanks where... 11-07-2013, 01:19 PM
ragulduy Re: Removing blanks where... 11-08-2013, 05:34 AM
  1. #1
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Removing blanks where blanks show blank but are code to show blank.

    You can also try this code as well

    Sub checkTwoCols()
    Dim i As Integer, lr As Integer
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Sheets("Petty cash")
    ws.Activate
    lr = Cells(Rows.Count, 1).End(xlUp).Row
    For i = lr To 2 Step -1
        Range("A" & i).Select 'you will be able to view the active cell during debugging otherwise you can delete this line
        If Range("A" & i).Value = "" And Range("A" & i).Formula <> "" Then
            If Range("A" & i).Offset(0, 4).Value = "" Then
            Range("A" & i).EntireRow.Delete
            End If
        End If
    Next i
    End Sub
    Hope this helps.
    Last edited by sktneer; 11-07-2013 at 11:12 AM.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code to Copy Non Blanks/Cells with Values until Formula returns as blank
    By FLani in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-16-2013, 10:18 PM
  2. [SOLVED] Find first non-blank cell after a group of blanks copy offset cells, find next blank, loop
    By gwsampso in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-21-2012, 06:11 AM
  3. Replies: 4
    Last Post: 08-29-2012, 02:45 PM
  4. Replies: 1
    Last Post: 04-26-2008, 08:00 AM
  5. [SOLVED] Hide show blanks
    By PCOR in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2005, 05:19 PM

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