Results 1 to 16 of 16

Need help tweaking macro

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2015
    Location
    San Francisco, California
    MS-Off Ver
    2013
    Posts
    11

    Need help tweaking macro

    I have the following macro which automatically hides rows that contain blank cells within a given range of columns:

    Sub DeleteBlankRows()
    Dim lr As Long, i As Long
    lr = Cells(Rows.Count, "A").End(xlUp).Row
    For i = 4 To 26
        If Application.CountBlank(Cells(i, "B").Resize(1, 14)) = 14 Then
            Rows(i).EntireRow.Hidden = True
        Else
            Rows(i).EntireRow.Hidden = False
        End If
    Next i
    End Sub
    How to I edit the macro to make it select every other row from B to O? I need a macro that only looks at B,D,F,H,J,L, and N and then a second macro which looks at C,E,G,I,K,M, and O.

    Thanks so much!
    Last edited by mlancaster24; 12-08-2015 at 12:29 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help in tweaking VBA Macro
    By vijey18 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2014, 11:36 AM
  2. [SOLVED] Macro tweaking and better way to import text file using VBA
    By zaska in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-26-2014, 08:29 PM
  3. [SOLVED] Tweaking an Excel 2003 macro
    By nharpaz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2013, 05:03 PM
  4. Tweaking of Macro Code to sort rows
    By swoosh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2012, 02:14 PM
  5. 'SEARCH' Macro Needs Some Tweaking
    By gnrjess in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2012, 12:34 PM
  6. [SOLVED] Tweaking an Outlook email Macro in Excel
    By John V in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2006, 05:25 PM
  7. Tweaking a Macro to Count Words
    By PGiessler in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2006, 07:45 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