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
Disclaimer: I am a beginner-level, self-taught casual 'programmer' with Python. Background: I have a script that takes Groupings of data from an .xlsx Workbook
I have the below code for one of my financial reports and I'm struggling with updating the code to make it more automated. The code creates a string of the colu
I have a big function with lots of branches of IFS; each branch uses different references of the worksheet: MYFUN = LAMBDA(i, IFS( i = 1, // a formu
I was working on an Excel document and I used the key combination Alt+h+w to wrap a text paragraph, but for my surprise that makes disappear all my sheets and c
I work in Finance and I'm pretty new to Python. I'd like to make a loop with openpyxl which copies the cell contents B2:B15 below in the same column. Ideally ma
Background I am making a spreadsheet that refers to information security license registration provided by the Japanese government (https://riss.ipa.go.jp/). The
We have produced some Excel files using Xmla Pivot Tables against Iccube schemas. Everything is working well except the fact that we noticed : Each Pivot Table