Results 1 to 4 of 4

VBA, Delete blank rows with no visible data in Column A

Threaded View

TylerLuk1 VBA, Delete blank rows with... 10-20-2015, 08:02 AM
antoka05 Re: VBA, Delete blank rows... 10-20-2015, 09:46 AM
JOHN H. DAVIS Re: VBA, Delete blank rows... 10-20-2015, 10:06 AM
JOHN H. DAVIS Re: VBA, Delete blank rows... 10-20-2015, 09:59 AM
  1. #1
    Registered User
    Join Date
    06-10-2015
    Location
    Philadelphia
    MS-Off Ver
    2013
    Posts
    14

    VBA, Delete blank rows with no visible data in Column A

    Hi everyone,

    I developed an order sheet in excel and wanted to make a packing slip on another tab for future tracking purposes. I created the order sheet and named it Thermafoil and on another sheet labeled "info" I developed formulas that will show the order information if the quantity (column B) on the sheet "Thermafoil" has a value . However, this leaves me with a bunch of blank rows on the info sheet. I have tried searching everywhere for a code that will automatically delete the blanks rows if there is no info in column A of the "Info" sheet.

    Any help or pointers will be much appreciated.

    Thanks in Advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Delete Rows Below if Any Cell in column is not blank:
    By Chad Bateman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2015, 12:51 PM
  2. Macro to Delete blank rows or column
    By sriku in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2014, 10:23 AM
  3. Macro to delete blank rows if column I is blank for the row
    By tiger10012 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-10-2013, 03:01 PM
  4. [SOLVED] VBA Find last row and column that contain data and delete all blank rows and blank columns
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-03-2012, 01:07 PM
  5. Replies: 1
    Last Post: 05-10-2012, 04:58 PM
  6. Delete Blank Rows-Blank Row between my data range
    By Bob@Sun in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-27-2010, 02:52 PM
  7. Delete ALL rows that have cell in Column (J) that looks blank
    By Sanne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2010, 11:10 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