+ Reply to Thread
Results 1 to 4 of 4

Find last row in column and delete everything below

  1. 04-08-2015, 10:55 AM #1
    rs1aj
    rs1aj is offline
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    Find last row in column and delete everything below

    I need a vba code to find the last row in column A, and delete or clear all the information below it.

    Thanks for your help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-08-2015, 10:59 AM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Find last row in column and delete everything below

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 04-08-2015, 11:04 AM #3
    rs1aj
    rs1aj is offline
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    Re: Find last row in column and delete everything below

    That looks like it will work. Thank you!!
    Reply With QuoteRegister To Reply
  4. 04-08-2015, 11:10 AM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Find last row in column and delete everything below

    You're welcome. Glad to help out and thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] I need to find & match the data in column in A with column B and delete both
    By RobinPrice in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-29-2014, 11:03 PM
  2. Find the value in Column B and delete the whole row
    By zit1343 in forum Excel General
    Replies: 1
    Last Post: 04-25-2012, 09:00 AM
  3. find value and delete column that contains it
    By fabrecass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2011, 09:56 AM
  4. Find Column heading and then Delete entire column
    By Kobayashi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2005, 05:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1