versions

1. This subject was already answered before: https://www.mrexcel.com/forum/excel-questions/911306-managing-autocorrection-excel.html?highlight=math+autocorrection 2. I used it in previous versions but it seems that it does not work in Excel 2016

I am trying to copy and paste data from the internet and it works fine at my work computer but when I do it at home it puts everything in column A rather than spread it out across the columns. Any suggestions as to why this may occur? I am most likely using different versions of excel at home...

All - I'm having occasional crashes but finding I dont have an autorecover version of the workbook - so typically lose what I've done! I then go and clear the exception for that workbook so its back to saving autorecover versions. Question being - I've got hundreds of workbooks knocking...

Hi Forum I have a list of dates in A1 (eg: 1 - 30 April), Names in A2 (not counting these) and a status (Seen or Not Seen...) in A3. I want to count the number where status = Seen within a date period - eg: 1-10 April. I am using Excel 2003 and 2010 so the formula must work in all versions of...

Hi, I have had a lot of issues getting jeanie to work on excel 2013 and windows 7 Now I have windows 10 and office 365 (excel 2016) How do i get jeanie to work looking at the links on various mods signatures - its only for windows 8 / 2013 versions Version 4.8 Excel Jeanie Html - Download...

the table contains a string that is too long for excel to display. if you edit the long value some data might be lost Does anyone know what this is? I dont know what happened, I have been building a spreadsheet for a few weeks now and everything was running smooth. Randomly during this versions...

I'm new to using VBA and I'm trying to figure out how, if possible to copy selected items from a listbox to cells on another sheet? I am using Excel for Mac 2016 and I know it doesn't have all of the same features as previous versions or the Windows versions. Also, I will be having several...

Hello All, I'm using Excel 2016, on Windows 10, and I will create my sheet and align my columns and change my fonts and everything else to look nice, and then when I email it to another computer and open it, some of the text in certain columns will get cutoff or change to ###. I'm also using...

I searched for answers for and came across the same question i had but none were responded to so i'll ask the question again.. I work within a large organization and release spreadsheet templates to many individuals. I would like to insure the most updated versions are being used (without...

Hi all, I did a macro, it works well in Excel 2010, but in 2007 it triggers "Compile Error (Syntax Error)" on the first IF... THEN, I'd need have the macro working in 2007 and 2003, besides 2010: Public Sub Color() Dim DataRange As Range Dim cell As Range Set DataRange = Range("A1:ZZ500") For...

Hi - I have a laptop that runs both Excel 2003 and Excel 2007. I wrote all code in 2003. My client is using 2003 but his code seems to stop after a certain point and I can get it to work fine on my computer....???! The code stops for him at... Workbooks. Open FileName:= "S:\Sales...

Worksheets("Main").Range("C3:GT69").Select Selection.Replace What:="X", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False I am working with version 03, and I do not have any issues with the above code. I...

Hi all. I wrote a macro in Excel 98 that is being used in Excel 2000. I don't have a copy of that version to test/figure things out with. The offending code that seems to be breaking everything is : Selection.Sort Key1:=Range("C14"), Order1:=xlAscending, Key2:=Range("B14" _ )...