Is this segment of code in a looping macro that cycles through the entire
workbook?
Norman
On Sun, Jul 5, 2009 at 10:54 PM, Norman May wrote:
> Try this:
>
> ActiveSheet.Cells.Replace What:="1234", Replacement:="", LookAt:=xlWhole, _
> SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=Fa
Hi Andrew,
Solution given by Norman is working fine.
Pls show your code so that we can understand what is the problem.
Regards,
Swapnil.
On Mon, Jul 6, 2009 at 9:49 AM, Andrew Ritland wrote:
> I tried your suggestion but the VBA still replaces all occurrences of
> "1234" across the entire workbo
@googlegroups.com
Subject: $$Excel-Macros$$ Re: Simple Question - Search and Replace for
Current Sheet Only in VBA
Hi Friends,
Please tell me about repalcement of (*)
Example
Validation_Type
Manual*** Check**
Manual***Check**
Manual** Check*
*Calling*
Manual ***Check
Hi Friends,
Please tell me about repalcement of (*)
Example
*Validation_Type* Manual*** Check** Manual***Check** Manual** Check*
*Calling* Manual ***Check **Manual**Check**
--~--~-~--~~~---~--~~
-
I tried your suggestion but the VBA still replaces all occurrences of
"1234" across the entire workbook and not just the active sheet.
- Andrew
On Jul 5, 2009, at 9:54 PM, Norman May wrote:
> Try this:
>
> ActiveSheet.Cells.Replace What:="1234", Replacement:="",
> LookAt:=xlWhole, _
> Sear
Try this:
ActiveSheet.Cells.Replace What:="1234", Replacement:="", 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