This [^] site is a good resource for VBA. I had typed out a detailed response to your query, but lost it when I hit the "Post" button :( I hope you can find your solution from the site I have pointed you to.

How 'bout something like this? function DaysSince(date) {    var msecPerDay = 1000*60*60*24;    return Math.floor( (Date.now() - date) / msecPerDay ); } // example: var days = DaysSince( new Date("2/3/2004") ); Citizen 20.1.01 'The question is,' said Humpty Dumpty, 'which is to be master - that's all.'

harveyhanson wrote: All I want to do is create a VBA script in Excel 2003 where I search through a spreadsheet, and delete every row where column E in the row (a date and time field) does not contain the text 2008. So e.g. If E1 contains 2008 delete row 1 If E2 does not contain 2008 keep this row (row 2) If E3 contains 2008 delete row 3 Continue until no more values The Rows collection of the worksheet has a Delete function which you can use to delete an entire row. For example: ActiveSheet.Rows(1).Delete will delete row 1. HTH

I won't write code for exactly what you need but I have got similar example. Sub CheckList() Sheet1.Cells(1, 1) = "Text1" 'Set text in Sheet1 Sheet2.Cells(1, 1) = "Text1" 'Set Text in Sheet2 Dim sValueFromSheet1 As String Dim sValueFromSheet2 As String sValueFromSheet1 = Sheet1.Cells(1, 1) 'Get Value of Cell A1 on sheet1 sValueFromSheet2 = Sheet2.Cells(1, 1) 'Get value from list on sheet2 If sValueFromSheet1 = sValueFromSheet2 Then Sheet1.Activate 'This will delete 1st Row Rows("1:1").Select Selection.Delete Shift Range("A1").Select End If ' Now for your question you will have to write your own code ' to do what you want to. I can't do everything for you. ' ' Hope this example helps you. End Sub - Stop thinking in terms of limitations and start thinking in terms of possibilities -

I think your problem is that if there is data in the cell but it doesn't match the value you don't go to the next row. try increasing LFindRow good luck

harveyhanson wrote: Does anyone know a good link to some source code for a world clock time(&currtime); draw_world(&currtime); details are left for implimentation. _________________________ Asu no koto o ieba, tenjo de nezumi ga warau. Talk about things of tomorrow and the mice in the ceiling laugh. (Japanese Proverb)

Me always referes to the current instance of an object. Since every open form ends up in the OpenForms collection, that loop has to check to see if it's going to hide the form the code is running on. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

MSN has full documentation on how to write input masks for the masked input control. I don't really know, I always write my own code. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Just set the Form Border Style to "None". Trinity: Neo... nobody has ever done this before. Neo: That's why it's going to work.

I hadn't ever heard of that one either, but it really exists... :omg: My advice is free, and you may get what you paid for.

It's an event handler, just like Form Load, that gets called when the form is told to close. Docs on it are here[^]. Dave Kreskowiak Microsoft MVP - Visual Basic

You can use a foreach loop on the Controls collection and look for items by name or tag, or use dynamic type checking to work out which items are textboxes. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

There is a form closing event that gets called whenever the form is closed. You can do what ever cleanup you need, or even cancel the form close in it. http://msdn2.microsoft.com/en-us/library/system.windows.forms.form.closing.aspx[^]

Sorted cheers, didnt realise they had to go on seperate lines, i was trying to concatenate them!

Ha ha, me being dumb, needed to call the my.computer event. Cheers

PHP date functions handle all that for you. Brad Australian - Captain See Sharp on "Religion" any half intelligent person can come to the conclusion that pink unicorns do not exist.

Sorted, cheers for your help :)

Sorted now cheers :)

Try If String.IsNullOrEmpty(strName) Then frmTeachBasics.Show