Questions tagged [excel]
Only for questions on programming against Excel objects or files, or formula development. You may combine the Excel tag with VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, and other programming related tags and questions if applicable. Do NOT use with other spreadsheet software like [google-sheets].
excel
288,271
questions
0
votes
0
answers
13
views
Office Script to Copy Rows From One Worksheet To Another
I have a shared excel workbook on SharePoint that is being used by a few users. This sheet tracks reach outs to counties across the United States. When a reach out turns into a lead it then gets ...
0
votes
0
answers
30
views
Average of Conditionally Formatted cells by color
I have a dataset (below) in excel that is conditionally formatted using the excel pre-set GREEN-YELLOW-RED color scale. What I want to do is find the average based by color of cell...and the whole ...
0
votes
0
answers
56
views
Passing an array of objects from C# to VBA Excel
I have a C# console application and Dll. I registered the dll as COM via interop. I used the
COM Visible property, GUID etc
Set Assembly Information, Build information to register it to COM
I ...
0
votes
2
answers
33
views
VBA Hlookup multiple rows
I'am trying to use HLookup with vba, but when i try the vba code i can't apply it to multiple rows, it can only be used for single rows "J2", i need HLookup vba code for many rows "J2&...
0
votes
0
answers
32
views
VBA Different cells accourding to the ComboBox Value
tPrivate Sub CSave_Click()
On Error GoTo ErrorHandler
' Variable Definition
Dim lr1 As Long, lr2 As Long, lr3 As Long, lr4 As Long, lr5 As Long, lr6 As Long
' Last Row ...
0
votes
1
answer
30
views
Excel VBA skip empty cells
I have a code to select a specified range and paste it into an e-mail. I would like it to skip copying blank cells within the range and paste only the cells that contain data. The specified range ...
0
votes
3
answers
42
views
Sum values based on XLOOKUP
the table below shows a list of employees and number of hours they have worked in that week. I am trying to come up with formula that would return the total number of hours worked per employee per ...
0
votes
0
answers
24
views
excelWB.write(fileOut); gives IllegalArgumentException
I am trying to use an excel to write the into new file using Apache POI. This is the method code,
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import ...
0
votes
0
answers
64
views
Copy File Names to Destination File
Hope all good with everyone.
I am trying to copy/paste file name to my destination workbook's column A. Below is copying data from all workbooks from a folder and pastes them to my masterfile.
...
0
votes
1
answer
13
views
PHPSpreadsheet, how do I set different layout for each series in a composite graph?
I am trying to create charts in excel using the PHP library PHPSpreadSheet. But when I generate a composite graph with multiple types of graphs together, I get overlapping data labels.
Stacked bar + ...
0
votes
0
answers
46
views
Why data that are being written to excel are not starting from the 'A' column?
I'm using pandas to copy data from one excel to another and the data are being copied just not at the right place.
I have this function that reads the data:
def updated_file(self, progress_bar):
...
0
votes
0
answers
19
views
excel found a problem with one or more formula references in this worksheet in a new workbook after only inserting one table
I created a new excel workbook and inserted one table. When I fill in a cell in the row below the table then due to autoexpansion the table is expanded with one row. Exacty how it supposed toe work.
...
0
votes
0
answers
25
views
DoEvents whilst a Time Delay Macro is running
I have a Macro in an excel sheet that selects a value in a slicer, I had a pivot which was converted to OLAP. When selecting a value in the slicer there is a short period of time where all the cells ...
-1
votes
0
answers
18
views
How to save data from SAP in Excel file with VBA code [closed]
Could you please help me with a VBA macro command to save the content of a generated report to my computer with a specified name? Thank you!
This is what I have until now:
Sub RunSAPScript()
'...
0
votes
1
answer
25
views
EXCEL Sumproduct COUNT 2 AND condition every nth COLUMN, counting blank and not blank
Good Day to all! as my title suggest I am having a problem with the sumproduct formula to get the result that for the following condition
Check and Count every 4th column range for NOT blank ...