J
Jim at Eagle
Why would I lose the findformat after the find finds the first cell meeting
the findformat. With one loop it's on the proper cell. But then it wants to
play with everything after that, but still within the proper range. I tried
placing the format everwhere except in the front yard.
Any help would be appreciated. Even stupid help might promt my mind out of
this ditch.
Thanks
With rngSearch
'NumberFormat = Accounting
Application.FindFormat.NumberFormat = "_($* #,##0.00_);_($*
(#,##0.00);_($* ""-""??_);_(@_)"
Set C = .Cells.Find(What:="", LookIn:=xlValues, LookAt:=xlWhole, _
SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=True)
If Not C Is Nothing Then
firstC = C.Address
Do
C.ClearContents
Set C = .FindNext(C)
Loop While Not C Is Nothing And C.Address <> firstC
End If
End With
the findformat. With one loop it's on the proper cell. But then it wants to
play with everything after that, but still within the proper range. I tried
placing the format everwhere except in the front yard.
Any help would be appreciated. Even stupid help might promt my mind out of
this ditch.
Thanks
With rngSearch
'NumberFormat = Accounting
Application.FindFormat.NumberFormat = "_($* #,##0.00_);_($*
(#,##0.00);_($* ""-""??_);_(@_)"
Set C = .Cells.Find(What:="", LookIn:=xlValues, LookAt:=xlWhole, _
SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=True)
If Not C Is Nothing Then
firstC = C.Address
Do
C.ClearContents
Set C = .FindNext(C)
Loop While Not C Is Nothing And C.Address <> firstC
End If
End With