Hello again,

Now it's generating runtime error 848 saying "Named argument not found"
taking me to the following line in the code:

'Look for Date in column A
Set c = newsht.Columns("A").Find(what:=MyDate, _
looklin:=xlValues, lookat:=xlWhole)

Do I need to name the date range as mydate in the source files?

Lucas


*** Sent via Developersdex http://www.developersdex.com ***