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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by 21MSU

  1. 21MSU

    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...
  2. 21MSU

    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...
  3. 21MSU

    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)...
  4. 21MSU

    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)...
See more

Part and Inventory Search

Back
Top