Can anyone explain what is happening here? I have some values in column A that I want to use with the match function. But there are some numeric values that don
Does any one know if it is possible to hook into the event when a user changes the 'From' address drop-down in Outlook 2016: I've gotten as far as testing ou
I am currently using a VBA code from Kutools that lets me combine all my worksheets into one combined "Master" sheet. However, every relevant worksheet is prece
I am trying to create a login form where the username and password input match the data on a sheet. I tried to code for if either the username or password is wr
I have a more than 1000 pdf files and I want to extract/pull data from pdf. If I use the pdf to excel conversion then it will take long time so I am trying pull
I'm trying to write a VBA to check if particular files exists in folders. For example in my code, there are 3 files that belong to folder 1, and 1 file belong t
I create a function to sum all the cells within a range as following Function SumTest(rg As Range) As Double Debug.Print "SumTest..." Dim s As Double s
I have the following spreadsheet. When ever there is an x in cell B I need to populate the d and e cells in the same row using an equation I have. if there is
I have 2 sheets named "Target Data" and "Pivot". I have filtered data in "Target Data" and now want to copy only visible cells in single cell of "Pivot" sheet.
I'm creating a Word VBA macro to insert a text frame containing an image and its caption, and then create a cross reference to it in the main document text. B
I have to pass data from Access database to a MySQL database attached to HeidiSQL automatically every minutes. To do that i put the data into excel files format
I have a function that aims to return the visible cells (as a range) after applying an autofilter to an inactive worksheet; the autofilter data is represented b
I have a database with a table that has as its primary key an autoincrement number field I call id. In the datasheet view, I want to create some new records us
I have a database with a table that has as its primary key an autoincrement number field I call id. In the datasheet view, I want to create some new records us
I have a form that is selecting emails based on companies that have expired insurances. Some companies have both a Business and personal emails whilst others ha
Private Sub CommandButton1_Click() Range("C10").Select For Range("C10").Value = 0 To 35 Range("C10").Value = Range("C10").Value + 1 Next En
I generate an email in vba and send it. I have a class which includes the send event for that email so I am able to tell if the email has been sent. My issue is
Is there a way to tell if some dynamic array, for example arr() as String is initialized? IsEmpty and IsNothing seems not to work with dynamic arrays. Currently
I set up a custom domain for my Microsoft 365 business account ("@company.com" is the custom domain which is really "@company.onmicrosoft.com"). I have two othe
I know this is a topic that is talks about a lot, but I just cant find the answer. I have a range. if in that range there is a word then I need it to go to the