How do I specify workbook rather than sheet in Cells.Replace in VBA:
Cells.Replace What:="x", Replacement:="y", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
--
Gary''s Student
How do I specify workbook rather than sheet in Cells.Replace in VBA:
Cells.Replace What:="x", Replacement:="y", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
--
Gary''s Student
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks