Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find date in another workbook
I need to find a date in Production Calendar.xls from Production Jo
List.xls. So far this is what I've got: Workbooks("Productio Calendar.xls").Worksheets("Phoenix").Range("A:G"). Cells .Find(What:="9/24/2004", LookIn:=xlValues, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext MatchCase:=False).Activate message = CStr(ActiveCell.Location) On the find statement I get an "Invalid or unqualified reference error. Actually, in the calendar itself the date is in format "24-Sep", no sure if that matters or not since it's a date. Any suggestions? Thanks -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Specific date in Biwwekly Based on date | Excel Discussion (Misc queries) | |||
Find cell in Excel2000 workbook with link from another workbook? | Excel Discussion (Misc queries) | |||
RETRIEVE DATA FROM ANOTHER WORKBOOK BY CHECKING ON WORKBOOK DATE | Excel Worksheet Functions | |||
Julian date - find next highest date/number | Excel Worksheet Functions | |||
Find the date of the coming up Saturday given the current date. | Excel Worksheet Functions |