$$Excel-Macros$$ Re: Simple Question - Search and Replace for Current Sheet Only in VBA

ment:="", > LookAt:=xlWhole, _ > SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, > ReplaceFormat:=False > > Norman > On Sun, Jul 5, 2009 at 9:14 PM, Ritland wrote: > > I know this must be a simple quesiton but I'm stumped. I wanted to do > the

$$Excel-Macros$$ Simple Question - Search and Replace for Current Sheet Only in VBA

I know this must be a simple quesiton but I'm stumped. I wanted to do the following search within the active sheet only NOT the entire workbook. ' Cells.Replace What:="1234", Replacement:="", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ Repla

$$Excel-Macros$$ Simple Question - Search and Replace for Current Sheet Only in VBA

I know this must be a simple quesiton but I'm stumped. I wanted to do the following search within the active sheet only NOT the entire workbook. ' Cells.Replace What:="1234", Replacement:="", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ Re