Get instant live expert help on I need help with vba left string
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
How do I find all formulas in 32 sheets over hundreds of rows that contain a partial string such as "This Company" where the formula looks like "=if(H2 = "This Company", "Yes","No"). This is a bit more complicated, but the upshot is that I need ti use VBA to locate formulas where the partial contents match a specific string. Any suggestions?
Solved by X. C. in 28 mins
Search thru Column H and Column I, and IF the cell CONTAINs STRING A, STRING B, OR STRING C, return VALUE 1 OR if cell CONTAINs String D, String E, OR STRING F, return VALUE 2, OR if cell CONTAINs String G, OR String H, return VALUE 3 Otherwise, return UNKNOWN.
Solved by T. H. in 22 mins
Column A has a string of data. Column B to O break out that data into individual cells I am trying to figure out a formula that will take number in Row 1 in columns B-O, and if it exists in the string of data, I want to put the number to the left of the / in column A to populate into those cells. I've done rows 2 and 3 to show what i want to be done automatically. For example: Cell E3 = 32 because Cell A3 contains "/10" and the number to the left of that / is 32.
Solved by A. J. in 18 mins
MY QUESTION IS ABOUT: Fixing Formulas DESCRIPTION: Search thru Column H and Column I, and IF the cell CONTAINs STRING A, STRING B, OR STRING C, return VALUE 1 OR if cell CONTAINs String D, String E, OR STRING F, return VALUE 2, OR if cell CONTAINs String G, OR String H, return VALUE 3 Otherwise, return UNKNOWN.
Solved by M. H. in 20 mins
My vba program is stopping after I give it the following command. ThisWorkbook.Sheets(s).OLEObjects.Add(Filename:=try, Link:=False, DisplayAsIcon:=False) try is set to be a string of text that link to and external pdf. It add the pdf in then the program stops.
Solved by V. B. in 23 mins