searchformat=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 Masters of Excel, I can't seem to find a way to have my code loop through all sheets in a workbook. I've never worked with loops before. What I have tried only goes to sheet 2 so I have removed that. Any thoughts to get me in the right direction. Here is the code I am hoping to execute on...

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 have the following hyperlink in sheet named 'Process' in cell B34: Text to Display: CLICK HERE TO PERFORM THE FOLLOWING: Type the cell reference: B34 The macro code is: Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink) If Target.Range.Address = "$B$34"...

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 am currently using this code to replace words in my data: Sub MultiReplace() On Error GoTo errorcatch Dim arrRules() As Variant strSheet = "renamelist" strRules = "A1:A100" Set rngCol1 = Sheets(strSheet).Range(strRules) Set rngCol2 = rngCol1.Offset(0, 1) arrRules =...

Hi, I am trying to tweak this code so that instead of manually typing in the code the new month in MM format every new month I can just reference the value in cell K1 that updates on its own. Is there a way that I can replace the month replacement value "/01/" with the data that is in cell K1...

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

Hi, a run time error 1004 occurs whenever the macro has finished looping through sheet names which contains "Country Financials". Your help please on what workaround should I do to prevent the error and continue to save the workbook. Thank you in advance for your help! Sub FormatFiles() Dim ws...