lookat=xlpart

This used to be quite fast, nothing has changed except software updates and office updates. now using business office 365 standard stuff set including Application.Calculation = xlManual Application.ScreenUpdating = False Application.EnableEvents = False Application.DisplayAlerts = False...

Hi Folks, I have a list of customers in column A. All of them start with "zz" which is simple enough to remove using... Range("A2:A" & lRow).Replace what:="zz", Replacement:="", _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=True, _ SearchFormat:=False...

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

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

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 Everyone, I have this bit of code that finds a word then removes other parts from the sentance in the cell, but I need it to find all of them not just one. here is the code: Sub Testit1() Set rngX11 = ActiveSheet.Cells.Find("Structure", lookat:=xlPart) rngX11.Replace What:=""""...

Trying a little humor with the subject. :) I recorded the following macro in excel, then shortened/simplified it. If I am in Developer Mode and run it from there, it works great, but.. I am trying to assign the code to a button. When I do and click the button, it appears to be running on...

Hi Guys, I have a macro that inserts rows in a workbook and is applied to all worksheets, this works great but I am trying to modify it to only work on the open worksheet (i am supposing this is activesheet) but it keeps failing. The code that is working on all the sheets is as follows Sub...

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

I'm trying to delete a range of columns that have dates (starting at 9/1/2017) as headers. I need it to delete from 9-2017 -> 8-2018, but when I run the code it keeps: Sep-17, Oct-17, and deletes Sep-18 and Oct-18. I'm not quite sure what is happening. Here is the code: Dim dateStart, dateEnd...

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

Hi My first post in this glorious forum so please be gentle :) I'm trying to get Excel to copy data from a text file and then arranging it for me, and it works like a charm. Except for 2 things! The characters ┼ and ─ seems impossible to replace :( I have figured out that they should be ANSI...

Hi! Thank you for reading my quick question! What I need: I select a cell, then a variable stores its value, and looks for it on worksheet "1" in column ("B:B"). Sub findstring() Dim CurrValue As String CurrValue = ActiveCell.Value...

Hi, when I run the following Macro it runs for the entire worksheet, however I only want it to run in the highlighted column (eg. If I click on column "H" to select the whole column, I do not want the macro to run outside that column). Here is the macro: Sub ReplacNames() ' ' ReplaceNames...

Ia a way to combine the following two codes. i.e. Replace "th" or "rd" with "" <colgroup><col width="72" style="width:54pt"></colgroup><tbody> Selection.Replace What:="th", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True...

Hi Expert, It's really a pain when we need to breakdown the long formulas in excel into vba. Been trying to do below but I really don't understand why the XXX partial formula is unable to be displayed when I run the macro. Here is my breakdown formulas in vba:- Sub SLAMatrixResol()Dim FORMP1...

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

I am sure this is just the dumbest thing I am overlooking, but does anyone have any insight as to why this first one works and the second brings back a error 91 Object variable or with block variable not set. Both my variables or 'Set' are declared as Ranges - hence having a .Row and a .Column...

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

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