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 Westi 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)
Thanks! I am getting errors on Set MainBook = Workbooks(MAIN_BOOK_NAME) Set MainSheet = MainBook.Sheets(MAIN_SHEET_NAME) Set LastEntry = MainSheet.Cells(65536, COL_DATE).End(xlUp) What will fix these? (I am new to VBA) I would like the macro to find the smallest date on each sheet in...- 21MSU
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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
- Post #2
- 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)
