+ Reply to Thread
Results 1 to 3 of 3

If Instr - find last row of data above and delete everything in between

  1. #1
    Forum Contributor
    Join Date
    11-06-2012
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2007
    Posts
    174

    If Instr - find last row of data above and delete everything in between

    Hello -

    Trying to do an Instr...if the string is found select row above and anything above that is blank and shoft cells up.
    Attached is an example file. Below is a snippet of code that I'm using(or trying to use).

    Please Login or Register  to view this content.

    Thank you

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: If Instr - find last row of data above and delete everything in between

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor
    Join Date
    11-06-2012
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2007
    Posts
    174

    Re: If Instr - find last row of data above and delete everything in between

    Yes it is:

    Please Login or Register  to view this content.

+ 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. [SOLVED] How do I use InStr to find a '-' in the filename?
    By Lee-337 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2013, 02:32 PM
  2. Find number of spaces in a string (instr)
    By DejaVu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2005, 09:26 PM
  3. is there an equal fxn for 'InStr' in excel. Not Find or Search
    By Arvi Laanemets in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 PM
  4. is there an equal fxn for 'InStr' in excel. Not Find or Search
    By Arvi Laanemets in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  5. [SOLVED] is there an equal fxn for 'InStr' in excel. Not Find or Search
    By Clausius in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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