instr function

I am trying to write a VBA module to help me identify the source of an excel file that I am given based on known cell values in the header. For example if ""Service Waiver Acknowledged"" exists in any position of the range A1:Z5 then I know this file came from Software1 whereas if ""AnnivDay""...

Evening gurus, I'm trying to run a formula on a adjacent cell column if the source cell contains two specific text which are defined. Formula 1 is to straight forward and will not be using InSTR function, however for Formula 2, the two specific text are "MODRETSUBUNIT" and "OPONEMS". A sample...

I can't seem to get the syntax right on my nested OR/ANDs section so I keep getting an error - please help! I'm sure there is a better way to do this than having all the InStr() OR InStr() but I'm not comfortable in VBA at all so I dont' know very much <code style="margin: 0px; padding: 0px...

Hi all. I've gotten a lot of use out of MrExcel in the past, and I'm banging my head against a wall here. Complete VBA newbie (my last years of programming was 20+ years ago). I'm getting the error "Object variable or With block variable not set" at the highlighted line. Option Explicit...

I am trying to see if a string contains a certain word or just letters like "ABC". This line of code I have works but ONLY if the word I'm looking for is at the very beginning of the string. If the word is say starting at the 5th character of the string I get a zero for the result. How should...

Hi guys, Instr doesnt seem to be matching properly for me, and I dont know what Im doing wrong. I get a match if my criteria value is the same as my search location value, but if the string is in the other string without matching it exactly, my code doesnt pick up on it...

Hi all, I am trying to correct an error on many spreadsheets (100+) we have located out on a network drive. I had a formula that was incorrectly written and needs to be updated. I've written the code below to be used in a loop macro that opens up each spreadsheet and updates the formulas (if...

I have macro that is to reference a list of word on a worksheet ("List")and then check for the list in a another worksheet ("sheet 1"). If a word is present in the list then certain formatting will be done to columns A:E of the sheet 1 worksheet. The macro partially works, except it fills the...

Hello, I am using inkEdit to change the color of all strings in my inkEdit textbox " SAVED " to be green. Only problem is that it will only make the first occurrence green and not any of the others. How do i fix this? thanks! Private Sub inkChange() Dim iStart iStart =...

Hi All I have cobbled together the code below to try and clean up some data. The code seems to identify the correct values but returns very strange and inconsistent results. What I am trying to do, is look down Col W and any cell that contains "VIN#" delete the "VIN#" and 9 characters to the...

Hi All, I'm hoping you could help me with an issue I've been having while trying to search for values from a label array on a webpage. What I'm trying to do is find a value from a label on a userform on a webpage and then have it display the results back on the userform. The loop seems to work...

Hi, I am new to VBA. My task is to copy all relevant worksheets into a new workbook. The name of the worksheets are stored in a worksheet called "Team list". I don't know whats wrong with my code. Can someone save me please?? If Err.Number = 0 Then For Each Worksheet In Worksheets If InStr(1...

I need help creating a function to compare strings; probably using regular expressions since it is a bit tricky. We have six strings: String 1: "V06+K73+U55+M67" String 2: "!M43" String 3: "!U67" String 4: "V06" String 5: "" String 6: "" In this case, "!" means 'not' so this statement would...