Using Data to locate cell

Last edited by VBA Noob; 10-30-2007 at 11:22 AM.

---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)

1. Copy the code.
2. Open workbook to paste code into.
3. Right click any worksheet tab, select View Code
4. VBE (Visual Basic Editor) opens to that sheets object
5. You may change to another sheets object or the This Workbook object by double clicking it in the Project window
6. In the blank space below the word "General" paste the copied code.