Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
searching for more current dates in Excel (urgent)
I am trying to bulid a macro to update a spreadsheet. The macro should open up a workbook, select the sheet and find a date that is higher (more current) than the last date on the main page. For instance UnitConditons1.xls Date VIS COLOR API SULFUR 2/18/2003...- 21MSU
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
date comparision in Excel (somebody please help)
I am trying to bulid a macro to update a spreadsheet. The macro should open up a workbook, select the sheet and find a date that is higher (more current) than the last date on the main page. For instance UnitConditons1.xls 2/18/2003 1:00:00 AM 2/19/2003 12:30:00 PM C-60.xls (Sheet1)...- 21MSU
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
