Is it possible to call a second sheet in a workbook using the private sub Worksheet_Change? When a value is entered into any cell in column A, I would like to use Vlookup to find a corresponding value in another sheet (Report10) in the workbook. The following code returns a #NAME? error.
Please Login or Register to view this content.