string

Hi guys, Currently im try to search a cell if it contain two specific text inside it using InStr function. However it is not working. Anything am I missing here? If InStr(1, (Range("L1").Value), "Hello ") > 0 And InStr(1, (Range("L1").Value), "name ") Then The tresult im loking for should...

I would like a formula that looks for a specific character in cell and returns the last word that contains it. Example: extract the last word (string?) from A1 that contains the "." (dot) character: A1 B1 FirstName LastName 1984 1:15.84 1:07.84 2 1:07.84

ISO VBA command to insert a dash (hyphen) as the 5th character from the left, and 6th character from the right, in a string of varying length, within an array. For example... Column Z contains the following list of values: MSEAVIMA0013S MSEAVIRM0016S MOLPVIRM0017S MOLS130012S MSEAVIRM0011S...

i have a repeating cell format i need to split into two parts, "Nr" and "Street, PLZ", format being: "Nr Street, PLZ" im getting the "Nr" as needed but the "Street, PLZ" is a total screw up and im not quite sure what im doing wrong Sub StringTitleRelocate() Dim vR As Range, vN As Variant, vT...

I have a situation like this: In one cell, I split the time ranges over several lines, for example 07: 15-10: 27 10: 35-11: 00 11: 15-12: 27 13: 15-13: 27 14: 15-18: 27 19: 15-20: 27 21: 15-23: 39 I know it would be more logical to have an hourly range divided over several lines, unfortunately I...

I am trying to match partial text in a string with text from a range on another sheet. The text fragment in the string is usually found after the last comma. For example: P38 Some Noise Text > Other Noise Text > 12-3456, 7890 Text I Want The range on the other sheet (Sheet2!$B$2:$B$505) will...

Hi, I am having an issue with the code below. Every time it runs and I enter a company name with an apostrophe an error is thrown that reads 'type mismatch run time error 13'. I am fairly new to vba, I have however tried to double up on the quotation marks *If Evaluate("isref('"" & ActNm &...

Hello again all, I have a macro that builds a calendar and searches sheets for details, placing them within the calendar if dates match. Each calendar day is only one cell, and so if more than one detail needs to go into the calendar day, I have it combine the details, separated by chr(10)...

Hi guys, I would like to know if there is a way to add more than 1 adjacent column for the presented code that Fluff helped me to modify in this Post Furthermore it's possible to apply a string extract (for example, extract the first 4 and the last 4 characters and put them in different column)...

I am looping through a connection to sync folders from a network drive onto a google drive and I can't figure out why cmd is giving me: 'robocopy' is not recognized as an internal or external command, operable program or batch file." error Here is my code: 'Here we can run the batch files to...

I have the following stored in a string (can be in a cell as well, if needed). Let's say s_String1(2,1) or cell A2: This text is permanent //Changeable-Text-Starts-Here This text can be changed by macro //Changeable-Text-Ends-Here This is also permanent I want to be able to remove...

I have a large VBA project I'm working on that uses the "Right" function a lot. All of a sudden it gives me an error message of... "Compile Error Wrong number of arguments or invalid property assignments." When I try to compile, with the "Right" Function highlighted. What's really strange is...

Hi, I have a list of thousands of names that need splitting into columns: prefix, first name, middle name, last name and suffix. The full names are varied and therefore the formulas I have tried thus far do not work on the whole list. Formulas I have tried thus far: Prefix...

Hi all, i have the below example of code that detects when BACK_COM is in cell T5 of Sheet1. When ba.placeBet is initiated, the program "Betting Assistant" will automatically call ba_betPlaced. What i am looking to do is rather than have the initial ba.placeBet triggered on Workseet_Change, i...

We received a excel sheet from a third party with macro's. It works fine when using Office2016 and Windows 10 build 1709 or older. But when using Windows 10 build 1803 it always goes to CONNECTION ERROR :S When we go to the original website it give back the response it should, but whenever...

I have a string ex: ".13 - LAR" I would like to get the first letters, or non alphanumeric and non numeric characters of the string. They are not always the same distance from the beginning so I can't use left or right function. However they always begin in the 6th or 7th position. Any thoughts?

Hi, I have posted a generic query regarding ‘PtrSafekeyword’ few days ago. However not able to find my post hence posting as new thread. I have below line of code in my macro and am required to update it with ‘PtrSafe keyword’ Private Declare Function GetPrivateProfileStringLib "kernel32"...

Hi, I've a list of item paths, each with a product code in them. The product code is always in the format AAA1111, but it's in a different place in each string, and each string is a differing length. Can anyone think of a forumla that will extract that 7 character code? I have 6,500 lines so...

The string can be like "abc123(456 k789)". It is to be splitted in array like array[0]=123, array[1]=456, array[2]= 789. So the problem is to split array based on numbers.

Hello, I have the following code to rename an existing folder but it gives me error in the line: OldFolderName As NewFolderName. Can I please have your help to make it work? Thank you. Private Sub CommandButton1_Click() If Me.ComboBox1.Value = "" Then MsgBox "CAR can Not be Blank!"...