replaceformat=false

Hello, I'm not the best at this yet so please don't judge my code below... I am having a problem in the code where I highlighted it blue. I know there are some options like using an IF statement but I can never get those to work. We have 13 tabs for the 13 weeks in the quarter. As you can see...

I have a small macro that uses the State entries to add Sales Regions to a spreadsheet. The macro adds a new column right of the Zip Code column, copies over the States and then uses the find/replace function to enter the Sales Regions. It's most likely not the most efficient method but it...

Hi, Please assist me. I'm tryig to create a macro replacing 00/01/1900 to blank. I have used control H to replace the date but it's not working. Please advise. Sub Macro5() ' ' Macro5 Macro ' ' Sheets("QA Coaching Data").Select Range("J2").Select Range(Selection...

I am using the following to replace text strings in a selection but I need to use the Lookin:=xlValues but it doesn;t seem to like itSelection.Replace What:="*H*", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Is...

I need a macro to replace the cells My code is: Selection.Replace What:="03.2018", Replacement:="04.2018", LookAt:=xlPart _ , SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False But instead "03.2018" should be what i copied from the cell A1 and...

I recorded this macro a little while ago, and I'm hoping someone can help me clean it up a little bit. What this macro does when it starts is it does all the screen flicking that hit the code when I was recording it. I'm getting a little better with VBA, and have been making my additions to the...

Can someone help me with a tweak to the find and replace code to replace in a different cell. Range(Selection, Selection.End(xlDown)).Select Cells.Replace What:="00600629", Replacement:="Christina", LookAt:=xlPart, SearchOrder:= _ xlByRows, MatchCase:=False, SearchFormat:=False...