+ Reply to Thread
Results 1 to 3 of 3

Delete Rows (w/Zero & Errors) but Not My Notes

  1. #1
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Delete Rows (w/Zero & Errors) but Not My Notes

    Using this wonderful code worked out with the help of forum gurus, but needs a tweek or something.
    Please Login or Register  to view this content.
    Objective is to delete the rows with Zeroes and Errors in the far-right column and this code does exactly that.
    It is also deleting all but the last row of my notes that are below the table area and in Column B, which is not what I want to happen.
    I don't understand why they are taking a hit when the code is looking in Column A for a row count, after finding the Find target, and not using Column B for anything that I can tell.

    Attached is a sample sheet with a Before tab showing the resulting problem of only one line of note remaining; the other tabs are for testing.

    Thanks for your help.
    Delain
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Delete Rows (w/Zero & Errors) but Not My Notes

    Because cell L53 has an apostrophy in it so it thinks the last row is 53.
    If you are happy with my response please click the * in the lower left of my post.

  3. #3
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: Delete Rows (w/Zero & Errors) but Not My Notes

    stnky, you got it! Yep, I missed that one.
    Sorry to bother with this one; I will check my templates for that leftover.

    Thank you,
    Delain

+ 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. Embed image into Lotus Notes with VBA - not using Notes.NotesUIWorkspace
    By pmor1503 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2014, 11:49 PM
  2. Not all rows pasting into Lotus Notes
    By Geetarzan in forum Excel General
    Replies: 7
    Last Post: 09-13-2013, 05:05 PM
  3. How to delete data within a table and ignore Natural log formula errors
    By thisguy23 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-11-2013, 12:29 PM
  4. Delete all rows with #REF errors
    By adgjqetuo in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-19-2013, 01:57 PM
  5. end notes, foot notes and an Index Table
    By thadacto in forum Word Formatting & General
    Replies: 1
    Last Post: 12-27-2011, 06:22 PM
  6. Delete Errors
    By Jbm444 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2010, 02:48 PM
  7. Excel 2007 : Cannot Delete NAMES with Errors
    By efernandes67 in forum Excel General
    Replies: 2
    Last Post: 12-27-2009, 11:24 AM

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