rorya

Hi All, Need anyone's help to view this VBA code. I'm not sure what's wrong. Repeated edits, but still came out error #9. Sub datasheet() Application.DisplayAlerts = False Worksheets(Array("FG_Store Bundle", "FG _Ship Bundle")).Delete --> Is there something wrong here ...

Hi, I use below code to split the text without any comma, Sub RSplit() For I = 2 To Cells(Rows.Count, 3).End(xlUp).Row mysplit = Split(Cells(I, 3).Value & " #", " ", , vbTextCompare) Cells(I, 3).Resize(1, UBound(mysplit)).Value = mysplit Next I End Sub But if text have...

Hi All, I would like to create VBA code for split a long text (items) into multiple columns as below picture (How to split the items) by using column button (Split Text) I used the code below but it didn't work while I was using it. Sub splitText() 'splits Text active cell using ALT+10...

In column D: to read folders name bid #, name, rev & location – which changes as per project or Rev. In column E: I hv combined file name (inclusive of D9 to 12) (=$D$3&" - "&$D$4&" "&D9&" Rev "&$D$5&".xlsb") it is same as read in the Folders. In column G: To extract the data this the...

Hello guys, Kindly help me with the code to format numerical data(like 1000,000.00) from calculated cells in my sheet to be entered into the textbox. I will be very grateful to get some assistance on this issue. I have tried this below; Private Sub TextBox1_Change() TextBox1.Value =...

in the data if one particular column header gets changed every month and i want to take that column and do the sum of that column(in pivot). Can help ?

Can anyone help me with a <acronym title="visual basic for applications">VBA</acronym> code for outlook, Problem: I have a D-list e.g. "xxxxteam@abc.com" what i want the code to do is whenever someone send an email to that particular D-list irespective the D-list is in To or CC an automatic...