Results 1 to 5 of 5

Is it possible to a macro go row by row and hide (or delete) and rows where column 1 is ""

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    48

    Is it possible to a macro go row by row and hide (or delete) and rows where column 1 is ""

    The title says it all, can throw together a sample sheet if needed but its basically a sheet that I get from my acct program that always has excess lines, and the lines I need always have a code in column 1 so I want to set up a macro to go line by line and hide or delete lines with blanks in 1.

    Something like a looping macro which I have a little exp with.

    thoughts??

    Thanks in advance.

    ~James
    Last edited by CDNcameron; 06-20-2013 at 01:33 PM.

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