Only for questions on programming against Excel objects or files, or complex 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.
General help regarding MS Excel for single worksheet functions is available at Super User.
I noted that when I invoke a macro (via Python) to do some stuff in my Excel workbook it takes longer than if I write the code in Python to do it directly. The time difference is about 50% less.
Is ...
Olá!
Estou montando uma macro que faz envio de mensagem de texto usando o Messages.Google.
Mas ele quando chega na parte Digite a Mensagem, ela n?o prossegue, e tambem n?o ponta nenhum erro.
Alguém ...
In order to improve the repeatitive work, I tried to access the Web site which is using in company using VBA.
So, I made code using VBA. And I checked it could be access the normal site such as google,...
this is my data and im trying to get the formula of it, how can i do it ( it dosent have to be using excell only but i dont know how to do it )
0 2 4 6 8
0 100 90 80 ...
I'm hoping to get some idea on automating copying some data in-between columns and worksheets.
I have to clear column C, then copy B over, clear B then repeat for A. Where it gets tricky for me is ...
Let's take the following data:
It seems that if you do =A2:A7 in Excel it will return a range whereas if you do the same in Google Sheets it will evaluate that to a SUM:
What would be considered a ...
asked 4 hours ago
David542
91.1k123123 gold badges350350 silver badges606606 bronze badges
First row is the header
I then want cells to be printed. The code runs successfully. Creates the file and the header but does not print the values like Cars, 10 etc from row 2. What's wrong in the ...
There is an online spreadsheet that has the option to "Download Spreadsheet". When you select it, it downloads the file as a .csv to the downloads folder. I want to download this spreadsheet ...
i need to create a method in my API controller, where the user upload a excel file.
After that i must read the excel and import some data to my database.
I found this article that seems very good (i ...
I have another excel problem. What function do I need to display only a lead time when there is an order placed? For this example, the 3rd Lead Time RN "0.19" will be displayed on Week 7 of ...
When sorting by the date I was surprised excel does not reverse the rows of data within the same dates.
I have the following table of data:
Date Narrative ...
asked 6 hours ago
niczoom
8933 silver badges1010 bronze badges
How to count the value as shows in the below example in vba or excel formula, Count column should have a value of the combination of column1 and column2.
asked 7 hours ago
jks
15311 silver badge88 bronze badges
I'm trying to build a lookup that adjust its array based on criteria for both row and column. Originally I was using sumif function that is using the correct arrays, however I found out that sumif is ...
looking for a code that will copy formula from Last Row to a new row in a table
or some code that make the new row with formulas :)
example: Last row number C25= A25+B25 so the new row Number 26 will ...
I'm so close on this, but keep getting errors if I try to use .Value or .PasteSpecial xlPasteValue. I'm not sure where to put it, but I've tried multiple options. I want this to work as is, but just ...