+ Reply to Thread
Results 1 to 2 of 2

can i clear data except leaving Header row using vba

  1. 12-08-2014, 05:59 AM #1
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    can i clear data except leaving Header row using vba

    i have headers in the 2 row like this

    BMS_ID level(1/2/3) Itemnum Original Mfg Name Original Mfg Part # Original Supplier Name Original Supplier Part # -->Header Row
    BMS_04763 manu --> this my data
    BMS_04764 usman
    BMS_04765 Usman
    BMS_04766 Usman
    BMS_04767 Usman
    BMS_04831 usman
    BMS_04832 usman
    BMS_04833 usman
    Reply With QuoteRegister To Reply
  2. 12-08-2014, 06:35 AM #2
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: can i clear data except leaving Header row using vba

    deleted forum-induced duplicate thread

    http://www.excelforum.com/excel-prog...using-vba.html
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...
    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. Problem with Page set up not clear previous Header
    By wayneao in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2014, 01:25 PM
  2. [SOLVED] Clear all data below header row in specific column
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2014, 04:50 PM
  3. a macro to clear a range of data based on cell result - i.e. if A1 = A2, clear C1: C10
    By Capolan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2013, 04:05 AM
  4. [SOLVED] When filtering repeated data, leaving the title(header) alone without deleting it
    By exlgh91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2013, 12:58 PM
  5. How do you clear the label in a column header?
    By susiesc in forum Excel General
    Replies: 8
    Last Post: 03-31-2013, 01:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1