Visual Basic code on how to search and delete value in Excel?

I need help on Visual Basic. For example, my excel data would look like this:

Date1 Date2 Date3 Date4…
value1 value2 value3 value4….

Basically I need to know how to search for Date3, and then the program will automatically delete the contents in range from Date1 to value3 (Date1,value1,Date2,value2,Date3,value3). Thanks in advance.

check link below

Related posts:

  1. visual basic – kindly convert this code…?
  2. Visual basic code question?
  3. Please give me some tips how to start programming Visual-Basic-Excel-Macro!?
  4. What would be the pseudo code for this piece of Visual Basic code that is underneath???
  5. Excel Delete Empty Rows, Columns, and Move Cells Up Visual Basic Macro VB
This entry was posted in Learn Basic Excel. Bookmark the permalink.

2 Responses to Visual Basic code on how to search and delete value in Excel?

  1. nicefx says:

    check link below
    References :
    http://support.microsoft.com/kb/247412

  2. Justin Wallace says:

    you can have a try on Spire.XLS which can help you on both C# and VB.NET.
    http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html
    References :
    http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>