Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resetting Find
I've found macros in my worksheet are setting Excels Find to non default parameters. I fixed this by the following as the workbook closes Dim Rng As Range With Range("A1") Set Rng = .Find(What:="", after:=.Range("A1"), LookIn:=xlFormulas, LookAt:=xlPart, searchorder:=xlByColumns, searchdirection:=xlNext, MatchCase:=False, matchbyte:=False) End With It works but has a bad side effect. Column A uses Private Sub Worksheet_SelectionChange to do stuff and this is being activated each time it's run. I suspect setting Range to something other than A1 (that does nothing), it might fix it. But is that a good solution, or is a completely different approach called for? Thanks - Kirk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resetting cells to zero value. | New Users to Excel | |||
Resetting Defaults | Setting up and Configuration of Excel | |||
Resetting PivotFields | Excel Programming | |||
Resetting VBA Windows | Excel Programming | |||
Used Range is not resetting | Excel Programming |