Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it [tag:excel-vba]. If it is about an Excel formula or worksheet function, then also tag it ...
0
votes
0answers
9 views
Excel vba macro to insert rows only functioning properly on first worksheet
I have a macro to insert row of data above a date if that date isn't today. It then adds today's date in the date column. This is done across 30 worksheets but only the first worksheet is properly ...
0
votes
1answer
6 views
Excel VBA InputBox not returning range values in loop
I have used this code in the past, but today it is not working for some reason. I have scoured the internet for answers, and from what I have read my InputBox is set up correctly. When i use the hard ...
0
votes
0answers
5 views
Get Powershell to search for blank cells from referenced row and not search the whole column
I would like to to search for blank cells in an Excel spreadsheet from a referenced row ($startRow) but instead Powershell searches the whole column (it starts at row 1).
How can I get it to start ...
0
votes
2answers
20 views
How to make REST call with VBA in Excel?
I tried to follow this example: http://libkod.info/officexml-CHP-9-SECT-5.shtml
but it gave this error
on this line:
Dim objHTTP As New MSXML2.XMLHTTP
I tried to use this example: How can I ...
0
votes
0answers
12 views
Excel closes when I close the main window in wpf
I have a Excel adding project which parses excel workbook and pops a wpf window. the problem is that when I close the window. closing action closes the workbook too.
the code is something like this ...
0
votes
1answer
10 views
EXCEL - My code only runs some times, is there a way to call a private sub by clicking a button on my sheet?
How do I call this function by pressing a button on my sheet? I want to be able to make sure that my macro runs, and currently it only runs if I open the code and then press enter after the last end ...
1
vote
0answers
8 views
How to make two buttons in Microsoft Excel sort a table upon click?
I have a spreadsheet with 5 columns (A-E). The first is "TEST YEAR", the second is "FORM", the third is "QUESTION, the fourth is "TAGS", and the fifth has no header title, but it still has data. At ...
0
votes
0answers
5 views
Simple copy of formula from 1 worksheet to another without getting a #ref error
This should be I hope a simple question.
I have a simple formula in a cell, worksheet name is Entry
=Entry!D10
I have 5 cells all with similar formulas in them. I want to be able to push a form ...
1
vote
0answers
9 views
How can I prevent a user from copying cell protection in an Excel worksheet
All,
I have an Excel workbook that contains some protected cells and some unprotected cells. Everything is working great, except when an end-user is copying from another worksheet that contains cell ...
1
vote
1answer
14 views
SumIf for strings
Am I able to use the SumIf function for strings? If not, is a UDF the only alternative or is there a way to accomplish this through index somehow potentially?
I am trying to concatenate the values of ...
0
votes
0answers
20 views
Getting COM object error while creating excel instance
Our application is using Excel Automation technique to create objects , It working fine up to few instance and when the load increase on IIS then excel instance fails to create the object
Our ...
-1
votes
1answer
9 views
AVERAGEIF Excel function into Google Spreadsheet
Alright, I was able to get it to get this formula working within excel:
=AVERAGEIFS($B$8:$B$88,$B$3:$B$83,"Coupons",$B$4:$B$84,"Holiday")
The formula averages the Open Rates for specific data-sets ...
0
votes
3answers
16 views
What are all the properties that i can assign to “with outlook” with VBA?
Like in VBA we can create object to run and manipulate other applications, i was trying to do few jobs in Outlook by writing a MACRO in excel.
Eg -
With OutMail
.Subject = " Event 1 "
...
0
votes
3answers
21 views
Excel Replacing Cell formatting with VBA
OK so i would like to figure out a way to change the cells within the worksheet behind the scenes of Excel 2007 with VBA so if i have something in Cell A1 and B1 then C1 will automatically populate a ...
0
votes
1answer
13 views
Excel: Search Data by Month, Person, then Sum value
I am working on a scheduling database that tracks the master schedule for all the classes, the student hours, and the hours teachers have worked. The problem I am running into is the final area of ...
