Results 1 to 10 of 10

macro that deletes certain results

Threaded View

dfrank macro that deletes certain... 06-30-2008, 01:35 PM
shg Please read our Forum Rules... 06-30-2008, 01:36 PM
dfrank For Each cell In Selection ... 06-30-2008, 04:13 PM
shg Assuming that otherwise does... 06-30-2008, 07:46 PM
dfrank appreciate the response, but... 07-01-2008, 08:11 AM
  1. #1
    Registered User
    Join Date
    06-30-2008
    Location
    ohio
    Posts
    10

    macro that deletes certain results

    I am making a macro that deletes #N/A's, but i want to add a few things to it
    that should be deleted:

    the phrases "total board", "total metal" and "Item", and any non-text (i.e. any
    number) that appears.

    this is what i have so far:

    Public Sub DeleteStuff()
      Cells.SpecialCells(xlCellTypeFormulas, xlErrors).Delete
    End Sub

    what do i add to meet my specifications? Any help is greatly appreciated.
    Last edited by dfrank; 06-30-2008 at 01:47 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