I'm working with 60 different datasets, each of them with a ton of data in them. I'm trying to build a loop to go through each of the datasets (they are text fi
Still in need of help :) I'm trying to adapt the following chunk of code to VBA for Mac (as the final implementation has to be on Mac): Dim ws as Object Dim res
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
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 am adding a new excel file to a SharePoint Library. The Library requires check-in or check-out. When closing the excel workbook, a dialog pops up in the backg
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 am trying to export excel using SheetJS/xlsx and want to format cell. I am using following code and excel is generating but can't format a cell. Can any one p
I need to clone exists rows to the work sheet dynamically. ex. I wanna copy row 28, 29 and insert into 30, 31, or 32,33, or more maybe, it depends on the data r
Private Sub CommandButton1_Click() Range("C10").Select For Range("C10").Value = 0 To 35 Range("C10").Value = Range("C10").Value + 1 Next En
Hi all for my first question! I am using ClosedXML (great solution to go to Excel) and everything seems to work as prescribed with the exception of making/forma
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 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
Here is the column entry for A1:A24 0,092 0,045 0,015 0,046 0,041 0,027 0,073 0,004 0,020 #N/A 0,000 0,001 0,004 0,000 0,032 0,000 0,002 0,140 0,005 0,001 0,251
Ultimately I would like to generate ML.NET code that can be consumed by Excel. I would generally assume that creating a DLL would be the most appropriate way.
My workbook consists of 2 sheets: Sheet1 is the primary dashboard that the user sees, while Sheet2 consists of a pivot table and regular table. I'd like to imp