incompatibility

Hello Receiving this error (translation from French) Error 13 Incompatibility type From this code GTD = WorksheetFunction.Clean(VBA.Mid(Sheets("Data_In_out").Range("GTD_Str").text, "AAAAMMDD,HH:MM:SS")) GAD = WorksheetFunction.Clean(VBA.Mid(Sheets("Data_In_out").Range("Gad_Str").text...

Hey all, I'm having an incredibly frustrating problem with adding a second data series type to my already established gantt chart of lab data. Essentially I want to add a target line to the graph so the guys know a deadline for the work graphically. Unfortunately the process doesn't seem to...

Hi everyone, I have an error in VBA code compiling with Excel 2013. I coded and tested on Excel 2010 and the VBA worked fine, so am stumped as to why it is not working on 2013, as I thought this was rather simple code. Does anyone note anything that has been disallowed in Excel 2010? Sub...

I don't use excel often so please forgive my ignorance! I have just saved my spreadsheet and when I opened it again I have lost text from some fields (there should be around 100 words in each field, I am left with less than half this number). I am assuming the problem has been caused by...