Hi

I am trying to select a cell containing a time (formatted: "hh:mm"), then opening another workbook and finding that time in a range.

#Dim ?????# Do not know what to write here!
#set a = Range("W92")#

#Windows(OtherWorkbook1).Activate#
#Worksheets(Sheet1).Activate#

#Windows.Application.Cells.find(a, Cells(0,7), , xlWhole, xlRows).Select#

I am using Excel 2010

ANY IDEAS

Many Thanks

Abbey