matchcase=false

I get an error when running this code a second time. If I copy the word 'Changed' from the field header in the workbook and paste it in the FS14 = "Changed" line it will run ok again one time, then errors out again. Line erroring out is the MsgBox Rng14.column line. Sub DDD() Dim lri As Long...

I'm having trouble with the Deactivate. The code works now but it keeps taking me back to the original page and not the page the user is trying to select. I'm probably doing something dumb but I can't figure it out. Thanks for any help! Private Sub Worksheet_Deactivate() Sheet5.Select...

I'm having trouble with this code working as a deactivate. As of right now I have it working as a 'Update Name' Command Button which works fine but users are forgetting to 'Hit' the button and the names they are looking for are not showing up in the updated list. So, if I could have the list...

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

Hi All I am attempting to loop through each sheet in a workbook, find the first blank after "A2" and therefrom create a range. The problem seems to be that whatever sheet the macro is assessing it always finds the value for the first blank on Sheet1 For Each rs In Wb.Sheets...

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

I upgrade from Excel for Mac 2011 to 2016 and am now getting the following error. This code takes |b and changes it into superscript b. Dim gg As Range Set gg = Range("a1:s16000") gg.Replace What:="|d", Replacement:=ChrW(&H1D48), LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False...

Hello! I know I am probably making a very basic mistake that my brain just isn't picking up on. I am writing a simple macro to replace special characters in a column (,.?#, etc.). This has to be used in several different sheets and the columns will vary. So I have the following code...

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

I recorded the macro below. I would like to change it so instead of the cell range identified, I would like it to run on whatever cells I currently have selected. Ideally, I would open a workbook with this macro, then open another workbook. In the second workbook I would highlight a range of...

Hi, appreciate any help with this frustrating problem. I am trying to retrieve statistical data from various monthly sheets ( Jan, Feb, March etc.,) to a single master sheet. I have set the code up to retrieve the data and all goes well until we get to August. As the data is not yet available...

Hi everyone, My company is purchasing thousands of item via Paypal and I am building a macro to get data from checkout page. Normally I want to get the Funding type and Funding sources. So here is what I do: 1) Copy whole content of the checkout page (Ctrl C) 2) Paste all content into my...

Below is the Macro I am using, but currently it only carries down to row 12. Can someone please help me modify so the Macro carries to last last line of data in the sheet. I will be using on multiple sheets in the future, so the row count may vary. Sub Byers()' ' Byers Macro ' ' Keyboard...