Hello everyone, I have certain problem of activating sheet name of another workbook. Like I have value of in Book1 Sheet1 A1 of "Jun-10" on Book2 I have a worksheet named "Jun-10".I just want to select that particular worksheet..or select the other worksheet if i change the value on Book1. Thanks!