find string

  1. S

    Sorting Copying and Pasting By State Abbreviation

    Hey guys, so here is my code: Public Sub newcopy() Dim WSCount As Long, StartCellRow As Long, i As Long Dim sht As Worksheet Dim region As String WSCount = Worksheets.Count - 2 Application.ScreenUpdating = False For i = 3 To WSCount + 2 region = Sheets(i).Range("E1").Text...
  2. T

    vba to insert a page break at every occurence of the word "New Record" in column 1

    I need to loop through column one and insert a page break before every occurrence of the string "New Record" as the cell.value.
  3. K

    Find a string in a cell

    <tbody> A B C 1 server1 Name Along with somedata server1 2 Name along with otherdata server4 server2 3 Somthing server5 other values server3 4 server4 </tbody> Hello Team, Here I have a typical question, where in a cell there is a sentance with many strings. i wan to...
  4. J

    Find first instance of a string then "group" all remaining rows together

    Hello all - What I want to accomplish is to group the City A's in rows 5 & 6 to 2 & 3 by finding the first instance of a string in the text column and then finding the remaining ones in the rest of the range and moving the entire row(s) up. Once it groups CITY A, then it will search for CITY...
  5. W

    Extract string starting with ... from a cell

    Hi! I'm trying to write a macro to extract a certain text from a cell. The string in the cell is the following usually: VIFIR - kód :k200010006……. What I need is to extract the 10 digit code from it. but it does not always start at the 14th character and not always with a k. Can start with...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...