help vba

I am unsurea bout why htis is not working and giving me a type missmatch error Private Sub SubmitCSR_Click() Dim LastRow As Long Dim ws As Worksheet: Set ws = Sheets("GP count") 'declare a variant array Dim ReceivedV(1 To 6) As String 'populate the array ReceivedV(1) =...

So i have multiple comboboxes in a worksheet. Is there a way i can fill all of them with the same listfillrange? The code for that for one combobox would be: Private Sub ComboBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Set col =...

Hey, So i have just posted a thread about how to insert a formula via VBA in the desired column of my Table. The answer i got worked perfectly fine. But as soon as i wanted to replace the original formula with my formula it stopped working and i guess i know why. the code which originally...

So basicly what my problem is is that: I have a table named "Teilbedarf". There is a column with the name "Benennung". I use a macro to delete the whole table every so often. But i need to enter a formula again in the first cell of "Benennung" after i deleted the whole table. How do i do that...

Hello members, As a lot of new members such as myself, I am quite green in my macros abilities. To cut to the chase... I have linked some live updates from the web in my excel spreadsheet. However, I would like to archive the data every 15 minutes and list it in each subsequent column. The...

Can anyone help with the following, I am trying to miss the email module when checking through my code, I want the to skip this part of the code: Call EmailOutOfDate (Email, ExpDate, Documents, Days Remaining) and check a value in the cell which determines whether or not an email should be...

Hi All, I am not sure that this is the correct place to post this, but I have a VBA question. I found a set of code online to do what I desire, but I need to modify it to suit my needs. What I am doing is this: I have a set of Names and values separated in my excel sheet as "Divisions" ex...

https://imgur.com/a/OyeoFv9

I have tried several different types of code to complete this and I can't seem to make it work. Here is what I am trying to do: I will have several different excel files that have multiple tabs. Within each workbook there are two tabs I would like to grab. Within the two tabs there are...

Hello guys, I have this problem exemplified in the picture bellow. The problem is: when I close workbook A, the macro sub B stops running. I tried this codes: Sub A() Workbooks("WorkbookB.xlsm").Close (Call other subs) End Sub Sub B() Workbooks("WorkbookA.xlsm").Close*...