Hi team,
Hoping you can help. When I open a new workbook, add the word "Bob:" in a random cell - for testing purposes - and run the following code...
...things work fine. However, when I amend the code with one additional line...![]()
Private Sub Worksheet_Change(ByVal Target As Range) Sheet1.Cells.Find("Bob:").Activate End Sub
...not only do I get a runtime error 1004 that highlights "Sheet1.Cells.Find("Bob:").Activate", but the black, rectangular cursor disappears from the worksheet view. I can still type into cells, but I can't see the cell that's been selected until I start typing and after I hit "Enter", the entered text appears in a different cell than the one into which I appeared to be typing.![]()
Private Sub Worksheet_Change(ByVal Target As Range) Sheet1.Cells.Find("Bob:").Activate Sheet1.Range("D2").Value = Sheet1.Range("D2").Value + 100 End Sub
To confirm, the event fires (Application.EnableEvents = True) but the execution breaks when basic operations are included. I've noted this problem in Excel 2013 32-bit (version 15.0.4859.1000) and Excel 2010 32-bit (version 14.0.7173.5000). This wasn't a problem 2 months ago but I couldn't identify any particular Windows Update for Office that might be the culprit. Any help would be appreciated!
Bookmarks