string

  1. D

    String Manipulation, get substring after space

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

    Calculate the difference in hours in a range write in a multiplelines

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

    Search Range For Text That Matches Part of String After Last Comma

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

    Error is thrown when I enter a name in the input box with an apostrophe in it e.g. Son's

    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 &...
  5. lockarde

    Highlight specific text in cell

    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)...
  6. Emanuele

    Multiple column and String extract VBA

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

    shell roboCopy 'not recognized as internal or external command, operable program or batch file' error

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

    Adding/updating text between a string or cell with text

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

    Cannot use "Right" Function. Apparently meaning has changed.

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

    Split variety of full names into prefix, first name, middle name, last name and suffix using a formula

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

    Convert Sheet Events to Macro's

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

    Excel 2016 - Macro working on Win10 1709 and older but not on Win10 1803

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

    find first letters in a string of alphanumerics

    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?
  14. B

    How to updated statement with PtrSafe keyword

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

    Find a 7 character code in text strings of varying length

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

    Split string into numbers in Excel VBA

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

    Error in code to rename existing folder

    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!"...
  18. Johnny Thunder

    VBA Help - Array Loop Won't Populate Cell????

    Hello all, I have a piece of code that creates an Array with my range of data and looks for a value in Column B, if the value equals a Declared string, then Drop a value in column ("O") if not, just grab the value from Column B and drop that in Column ("O"). The logic of the code seems fine...
  19. O

    64 bit issue

    Hi I'm working in 32 bit Excel but I'm getting error in Excel which is 64 bit. How do I edit the codes in 64 bits. Public db As DAO.Database Public rs As DAO.Recordset Public sql As String Declare Function sndPlaySound32 Lib "winmm.dll" Alias _ "sndPlaySoundA" (ByVal lpszSoundName As String, _...
  20. T

    Problem Adding Email Signature

    Hi all, I have the following code and all is working ok, apart from it is no longer adding my set signature in Outlook . If possible could you have a look and amend as required. Sub ScorecardPdfEmail() Dim OutApp As Object, OutMail As Object Dim fname As String, sendto As String...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top