I'm trying to learn VB using MSoft on-line help as a reference. I know, not the best in the world for folks who don't know VB. I'm running a binary search on a large file, and when I find a match I move several cells from a hidden sheet to an Excel spreadsheet-based form. The following statement kicks off a macro: "Private Sub Worksheet_Change(ByVal target As Excel.Range)". But when I move data from one sheet to another the macro runs with every move, and the search fails. I'd appreciate anyone telling me how to either move the data without running the macro each time data is moved, or how to condition running the macro when only one cell is changed. I could add a command button but I didn't want to create a another step for the users.
Thanks,
Bidwin
Thanks,
Bidwin