Excel - steepest and least steep lines?
Is there any way in Excel that I can get the steepest line and least steep line, given a linear graph? If it's not ...
Insert picture into Excel cell [closed]?
Closed. Th...
Finding pass rate in Excel within a date range?
I have a large control sheet in Excel with over 1000+ students on it. I have three columns that I want to use which ...
Creating Unique ID with Sequential Numbers in Excel?
I found what I thought would help me create a unique ID for each row of data in an Excel spreadsheet. Ideally, I ...
Way to run Excel macros from command line or batch file??
I have an Excel VBA macro which I need to run when accessing the file from a batch file, but not every time I open i...
How to fix Error Code 424, Object Required?
I have an ActiveX Listbox and Combobox which I'm attempting to get the combobox list dynamically populated dependent...
Vba code: Filling the blank cells with zero dynamically?
I need to fill my blank cells in a worksheet with zero. Currently I was doing it for C12:H35. Can someone please tel...
How can I convert a range to a string (VBA)??
What is the best way to convert a range of cells to a string? I have a function that only takes a string as input so...
Excel VBA Sending emails with multiple attachements?
So we are holding this big event and I have an excel sheet with everyones name, email address as well as their itine...
SendInput VB Basic Example?
I hope someone can assist, I trying to find an example of a SendInput code that simulate keyboard commands, I wish t...
Formula to Calculate Subscriber Churn Revenue?
I'm trying to sum up 12 months of subscriber revenue factoring a 6% monthly churn (assuming no signups) to come up w...
Replace cells containing zero with blank?
I have a very large amount of data A4:EW8000+ that I want to replace cells containing a zero with a blank cell. Form...
VBA Excel Run-time error Automation error?
I had a Run-time error '-2147418105 (800100007)': Automation error The object invoked has disconnected from its cl...
Identifying Excel Sheet cell color code using XLRD package?
I am writing a python script to read data from an excel sheet using xlrd. Few of the cells of the the work sheet are...