Thread
:
How to select Formula cells with red interior?
View Single Post
#
12
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
How to select Formula cells with red interior?
First, make sure you read that second post--with the fix.
Second, the stuff before this line essentially just set the colors in the
Edit|replace dialog. That other stuff didn't actually do the Replace|All
portion.
Third, make sure you read that second post--with the fix!
wrote:
Dave,
What is the purpose of the "at the end" VBA statement below? In the sequence, it seems to be after
the color change. Maybe VBA needs the aggregation of all the code statements
that you separated for clarity?
Thanks
Activesheet.Cells.Replace What:="", Replacement:="", _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _
SearchFormat:=True, ReplaceFormat:=True
Dave Peterson wrote:
.Cells.Replace What:="", Replacement:="", _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _
SearchFormat:=True, ReplaceFormat:=True
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson