Find and Replace with condition
Closed
smuneeb
Posts
67
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Apr 24, 2016 at 01:09 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 25, 2016 at 12:16 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 25, 2016 at 12:16 PM
Related:
- Find and Replace with condition
- How to replace a word in word - Guide
- Air condition lidl - Home - Apps & Sites
- If condition in excel - Guide
- Replaced isa and vesa bus standards. - Guide
- Available memory less than 15mb condition zero - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 25, 2016 at 11:25 AM
Apr 25, 2016 at 11:25 AM
Hi Smuneeb,
Try this:
Select your range.
Right-click sheets tab and select "Select all sheets".
Hit Ctrl+H to open find and replace.
Enter your criteria and hit OK.
Works for me.
Best regards,
Trowa
Try this:
Select your range.
Right-click sheets tab and select "Select all sheets".
Hit Ctrl+H to open find and replace.
Enter your criteria and hit OK.
Works for me.
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 25, 2016 at 12:16 PM
Apr 25, 2016 at 12:16 PM
Hi Muneeb,
No problems here. But you didn't mention anything about a macro in your original post.
Here you go:
Best regards,
Trowa
No problems here. But you didn't mention anything about a macro in your original post.
Here you go:
Sub RunMe()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Range("D11:D510").Replace What:=".", Replacement:=vbNullString, _
LookAt:=xlPart, MatchCase:=False
Next
End Sub
Best regards,
Trowa
Apr 25, 2016 at 11:59 AM
Trowa
I think you are not happy with me.
Ok No Problem, if I did something wrong with you then I apologies
I request for Macro
but Thanks for your reply
Regards
Muneeb