Get instant live expert help on I need help with vba long 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
Hi There, How to extract a group of text from a long string of text in a column
Solved by B. J. in 15 mins
i need a long VBA macro that involves several conditions, please help?
Solved by K. J. in 27 mins
I'm trying to type in the Header but it keeps telling me the string is too long. It is not too long because even if I make the font very small it still tells me this.
Solved by G. H. in 16 mins
Hi I have a piece of code that suddenly stop working: All code in the sheet...cell is not working Private Sub Receipt_Click() Dim customername As String Dim customeraddress As String Dim invoicenumber As String Dim r As Long Dim mydate As String Dim path As String Dim myfilename As String lastrow = Sheets("01").Range("B" & Rows.Count).End(xlUp).Row r = 5 For r = 5 To lastrow If Cells(r, 15).Value = "done" Then GoTo nextrow Product = Sheets("01").Range("R2").Value ...working studentname = Sheets("01").Cells(r, 2).Value...not working Cells(r, 15).Value = "done"...not working
Solved by E. D. in 14 mins
I have a SUMIF formula that is returning a #VALUE error. I think it is due to the criteria string being too long. This string is the name on 3 other tabs that I am adding together on the main tab. I need it to look at the 3 tabs for this string and then return the costs. How can I shorten the string when that is the name of the company?
Solved by X. W. in 17 mins