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,277
questions
0
votes
1
answer
12
views
Preventing Excel Ribbon CustomUI IRibbonUI variable from 'losing state'
We have a custom UI with two added ribbons in our Workspace Environment. This CustomUI has an OnLoad event that loads the Ribbon's pointer variable into memory for access later. Unfortunately, there ...
- 95
0
votes
0
answers
11
views
Excel files stored in USB drive, seem to be altered after it got plugged on to a computer [closed]
my boss gave me a usb thumb drive to save some music in it. In the drive there was already saved some excel spreadsheets, I didn't touch them, even though my boss said that they have some kind of ...
0
votes
0
answers
17
views
VBA to determine remote desktop user
I would like to use VBA (64bit) to determine if a user is running VBA/Excel from a remote computer. For example, if PC#1 uses Chrome Remote Desktop (CRD) to remote login to PC#2, the VBA code on PC#2 ...
0
votes
1
answer
8
views
How to prevent the message "File open in another application" when creating excel instance
I was running a PowerShell script perfectly fine earlier, but for some reason this message popped up that's saying the file is open in another application. I have checked task manager and the excel ...
- 1
-2
votes
0
answers
16
views
Excel Formula to Calculate the nth date value based on subset of data [closed]
I have scoured the internet but to no avail. My problem is this:
I have a table like the one in the image with date values for planned and actual dates (I tried to create it using the markdown format ...
- 47
1
vote
1
answer
29
views
nested "if and" statements in excel
I have the below table and have an 2 "IF AND" statement there:
May I ask, if I would like to combine the "IF AND" statement together, how should I go about it? What I am trying to ...
- 577
0
votes
0
answers
15
views
Excel - Find all duplicate entries in Column A (and its Row), copy each dupe entry so they're grouped together, to new Spreadsheet
My apologies for this and this is because I need a solution relatively quick, and I have very little Experience in Excel Functions, VBS, etc. meaning, I won't hit a goal I need very soon.
My goal Move ...
0
votes
0
answers
14
views
Accessing a sheet from a different workbook [duplicate]
I have 2 workbooks, one hidden and one the user can see.
The hidden workbook contains all the code (including the line below)
Note: codeName is the code name of a sheet in the active (non-hidden) ...
- 21
0
votes
0
answers
8
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
26
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 ...
- 43
0
votes
1
answer
41
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 ...
- 1
0
votes
2
answers
30
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&...
- 13
0
votes
0
answers
30
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 ...
- 1
0
votes
1
answer
25
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 ...
- 3
0
votes
2
answers
27
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 ...
- 49