.replace

Good Afternoon could someone please update my Macro below it only keeps row data that contains data between ## ^^ ** i would like to replace with the following 3 unique data starting in A10 down MON: Data Sent SURVEY: many thanks Sub DelRws_v2() Application.ScreenUpdating = False...

Hello, I seem unable to find a way to first copy n paste say Column B:B to sheet2 say A:A (I do this fine lol) Then I want to run a find and replace on Sheet1 col b:b without the find & replace doing the same thing to sheet2. As I want to then copy sheet2 a:a to sheet1 a:a to create my cross...

Is there a way to replace numbers with blanks. Example: .replace what:="number", replacement:="" I want to replace all numbers.... Thanks!

It was one thing to write this formula and have success but getting it to VBA has been killing me. I Couldn't use Vlookup to return items as one lookup value may have several entries and several results on the opposing sheet. So I concocted the formula below. Then I tried to put it into my maco...

The cut and sort feature is not working. I need it to look in column 3 and if any of the 3 names appear cut and place them at the bottom after the sort placing 3 empty rows between the final row and the ones I am pasting. Here is the code...

Guys, i have a simple code: With Rows("3") .Replace What:=",", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False End With The goal is to change the regional settings. I want to get rid of ","...

I have a vb looking to pull rows that return a certain value and place at the bottom, but it errors if it doesnt find a row with that name. Sometimes the sheet will have it and sometimes not, how do I tell it to ignore it and move on if that name doesnt appear. Here is the code so far: With...

Good day fellas, I was trying to use this Sub Macro1()Dim Arrreplc As Variant 'Making Replacements all at once Arrreplc = Array("(", ")", " ", "-") With Range("D2:D9") .Replace What:=Arrreplc, Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False...