Results 1 to 43 of 43

Need to delete multiple lines in cells but keep one

Threaded View

  1. #11
    Registered User
    Join Date
    10-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Need to delete multiple lines in cells but keep one

    Amazing, it works almost exactly right. There is only one problem.

    1. The red dates and italic dates after strikethrough dates are being deleted. See rows 21,22,23,25,51 column o (format?),61,62,64,and others -- AFTER RUNNING THE MACRO

    I posted the updated file with the improved macro. I included in the file the desired results and the original info.

    The last thing to fix is to keep the red and italic dates that follow strikthough dates or that are the first line in the cell.

    Thanks for all the help. Almost Solved!
    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] Macro to delete lines where there are successive blank cells
    By Footley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2012, 12:16 PM
  2. [SOLVED] Macro to Delete useless lines, rearrange by dates and skip lines between different days.
    By Tmc2159 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-12-2012, 02:15 PM
  3. Merged Cells and multiple lines
    By ATLGator in forum Excel General
    Replies: 2
    Last Post: 03-29-2012, 10:03 AM
  4. Compare cells to delete lines?
    By lancekeith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2006, 08:35 PM
  5. [SOLVED] Is there a way to delete multiple lines at the same time beside u.
    By cherry in forum Excel General
    Replies: 2
    Last Post: 04-11-2005, 02:06 PM

Tags for this Thread

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