$$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