I seem to have a mental block right now. What I am trying to do is have VBA that copies a row, e.g., A2:H2 (values only is a must) into another worksheet once a specific value is added to column E. The functionality my code is currently lacking right now is copying values only for the row range into the other sheet.I seem to have a mental block right now. What I