Would it not suffice to redo the vlookup within the code and just return the found string to the desired cell on the worksheet for the Target of the Worksheet_Change event? Your sheet than wouldn't have to recalculate as there wouldn't be any vlookups present in your worksheets. Hope you find this helpful. Cheers, Roel

For an example of using VLOOKUP with a HYPERLINK Worksheet Function see my sheets.htm page.. This is the simplest example that I can come up with. Note the use of TRUE in the formulas indicating that the value found in the table does not have to be an exact match but must be less than or equal to the lookup_value used. Sheets(Array("101", "103")).Select The above is a line of code produced by the Excel macro writer. I need to iterate thru several lines of a worksheet and pick out appropriate items to put into the array statement.