I am creating an activity tracker in Excel. I'd like to be able to "Select all that apply" from drop down lists in two separate columns on the same sheet. I am
I wrote a macro to check if a date is the last day of a month. If so this cell should blink every 1 second, so I'm calling a Do While loop. I want to start the
I have a program which writes to a spreadsheet using openpyxl. Upon execution of the program, the cells are filled as expected but the spreadsheet becomes damag
I'm trying to use two custom lists to order the columns in a specific reach. First I define the two custom lists (arrays) and in the .Sort statement I give the
How do I color all the series (lines) in a specific (selected/current) chart the same color? I have the following, but it does nothing: Sub Same_Color() Dim
The Sunburst chart type was introduced in Office 2016 / 365, along with some other new chart types. I'm trying to work with the chart type in PowerPoint, but it
I am trying to add two sheets in Excel file using my php code. Here is the code $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel= $objReader->load(SS_AD
The columns of interest are bonus? and points_earned. For each day, players submit a number of guesses, and I'm trying to write a formula for the bonus? column
The accepted wisdom is that using a construct like Dim dict As New Dictionary is poorer in performance than Dim dict As Dictionary / Set dict = New Dictionary.
How to play local video file on loop on an excel userform?
I have an excel file with about 500,000 rows and I want to split it to several excel file, each with 50,000 rows. I want to do it with pandas so it will be the
I'm working on a school project to compare if date1 is equal to date2 - 1 (date1 is one day earlier than date2). date2 is located one cell below date1. This is
I have a pandas DataFrame that I would like to write to Excel. For one column, I have data values that are comma-delimited strings, like "val1,val2" or "val1,va
I built a coded UI test and I want to make it a data driven test , I want to get the data from an excel file ( Data.xls )located in the same directory with the
I run into run-time error 1004 Works if I use the cell as an argument but I don't want to constrain to one cell. I can get this to run if I use an input param
I have created a macro that opens a excel workbook and performs some operations and then at the end it closes the file.The macro is running fine. Now, when I o
We have an internal web application that accepts a file of varying formats from a user in order to import large amounts of data into our systems. One of the mo
I am rying to ge the values of PivotField in PivotTable(1).Pivotfields, then I am trying to get the the filter value to string(str- Declared as string), It is w
I have the following code, which should simply open a workbook from a master workbook to allow me to paste some information which I will later retrieve from a d
I'm trying to open a HTML file in excel (from VBA) so that the HTML inline styling is preserved. Are there any special ways of doing this because currently I've