excel 2013 add ins

Hi Guys, I'm working on below code, end result is okay, but I'm getting the MsgBox thrice. After editing the cell when I press enter its giving the msg & have to press ok/enter another two times to deactivate the msg. This code is running on "Worksheet" with change event. Need your help to...

Hi All We hold our data in Salesforce Professional. Every day I have to go through the process (in Salesforce) of exporting .csv reports to Excel 2013 to then manipulate the data. I am presently in the process of automating the Excel part with macros. Can anybody advise whether there is a...

How can I get DatePicker to work (or any other calendar function). I currently have a sheet with it on excel 2003 with only x32 (work PC). When I am building the macro/s on my home PC (2013 x64) it goes away and I can't seem to find it in the additional add-ins.

Hi I had a client access data transfer add in for excel 2013 that was working perfectly. Then I got a spreadsheet with a macro that I had to enable and add the Developer add in. When I went to run a data transfer, the add in tab was gone. I went to options/add ins/COM add ins and the data...

Hello, I'm trying to run a simple regression analysis on my Y and X variables but I get this error 'Regression - LINEST() function returns error. Please check input ranges again'. I have checked that my columns does not contain any blank cells. What else can be a reason for this? I really need...

Hi, I am currently running the 64 bit version of excel 2013. Are you aware of any add in like ASAP utilities that will work with this version? I am looking for the date fixing feature in particular. For instance, 12-03-2014 would show u in my data as 12/03/14 or 12.3.2014 ASAP utilities fixes...