cellslrow

So I have this sheet that automatically seperates the data byt column D value then uses that value to create a formatted "Header" for each group and places the name from D into the newly created header. My question is is it possible to add the sum of G in the header as well? Heres my code Sub...

So I am using this code to seperate my data so that each line with the sAME NAME IN COLUMN d ARE TOGETHER BUT A MERGED GROUP OF CELLS ARE INSERTED BEFORE EACH NEW NAME. aFTER THE CELLS ARE INSERTED THE ROW IS MODIFIED AND ALL WORKS PERFECT SO FAR. What I'm still needing some help with is once I...

Hey guys, if I want to Increment the Range that I have setup below for Now + 1second and then Now+2s.. ect ect.. How do I do that? I tried Now + TIME(0,0,1).. and it gave a mismatch error. Sub Fixer() Worksheets("Default").Activate Dim lRow As Long lRow = Cells(Rows.Count, 3).End(xlUp).Row...

Hello, I want to remove all duplicates but keep the last one. I found this code and adapted it to my situation. But I got stuck because the code only compares and removes the next value upwards in order to keep the last duplicate and delete the rest. But I have 3, 4, 5 or more duplicates. Can...

Hi, I am trying to locate a specific row number using vba. I need it to be able to look at the contents of a combobox and search for this value in the worksheet and then return the row number that the function returns. Once I have this value (lRow) I can use this as a cell reference Using...

In a userform I created to collect data, I have several textboxes, drop-downs, and checkboxes. The workbook contains two worksheets that are viewable, and a few that are hidden. The two viewable worksheets, "SurvData" and "Surveillance Data Entry" are available to store the data and "call up"...

Good morning, i have been trying various code, and copied some i have found on the internet, but am unable to get any to work. I am trying to remove the character "/" from column i , which contains numbers in this format 111111/22/11111111///11 this was the latest attempt, is there a reason...

Dear all, This is the code I found on internet. How can I modify it so that it compares with multiple values? I.e. insert a row if there value change not only in "A" column, but also it there is a change of value in "B" column as well? Sub InsertRowAtChangeInValue() Dim lRow As Long For...

hello, I am trying to convert lines of data to XML format and save them however I keep getting the error : 'Run-time error '-2147024773 (8007007b)': The filename, directory name, or volume label syntax is incorrect.' The 'doc.Save sFile' gets highlighted when i click debug. I ma very new to...

I'm always having problems with sheets activation. In this case my range returns as nothing. The comand is activated in a combo placed in a different sheet of the same file. In any of the set options the result for my i range is "Nothing" and the error if I move on top of the line is Error...

Hi Everyone, I would like to ask for some help writing a few lines of codes to speed up the generation of a few reports. I would like to have the code delete a column if the column only contains text. So far I have the following code I have created through a bit of research online Dim...

Good Morning, I have a directory with 20-30 files (it could change every month) with all the same layout, but different amount of rows. I need to total up two columns, and came up with the following, but it is erroring out on the lRow line. I should mention that I've used this code when...