Please help me to determine if the issue is with the Office version or else.I am using Office 2003 SP2 at work and I have to deliver the application in Office 2003 format only which is its current format.
#Excel vba on error does not work excel 2016 code#
Sheets("Sheet1").Range("I8").PasteSpecial xlPasteValues, xlNone, False, TrueĪbove snippet is working in Excel 2007 along with other code I wrote but when I execute it in Excel 2003, the code execution stops with out any error the moment it encounters the last occurrence of Range object. 'Copies the data from RangeA in Sheet1 and pastes in Sheet2
![excel vba on error does not work excel 2016 excel vba on error does not work excel 2016](https://i.ytimg.com/vi/RYI6P3r6Jmc/hqdefault.jpg)
The sheet Sheet1 is present in the workbook. Here are the snippets using Range object. Also, I use Range object to copy the data from one sheet and paste to other.
![excel vba on error does not work excel 2016 excel vba on error does not work excel 2016](https://i0.wp.com/images.saymedia-content.com/.image/c_limit%2Ccs_srgb%2Cq_auto:good%2Cw_700/MTc1MDE0NjM3NDU1NDE5MTEy/how-to-use-the-vlookup-function-in-ms-excel-2016.png)
The code is referenceing the Range object to access the cells of a worksheet and reading and writing data to them. I am facing an issue regarding the VBA code consisting the use of Range object. Sheets ("Sheet1").Range("A2:L2").PasteSpecial _ The original code was originally written in Excel 2016 and has been functioning perfectly up until the latest company approved version of window 10 was updated. Sheets("Sheet1").Range("A2:L2").ClearContents The macro works perfectly in Excel build Version 1902 (Build 11328.20318) but does not work in Version 2002 (Build 12527.21416). Private Sub Worksheet_Change(ByVal Target As Range) It is working fine on my home PC with office 2007 and at work with office 2003 but when I integrate it with other excel workbook, it doesn't execute. It is just pasting the cell range Days and Months depending on whats the value in B2 and B3 is not blank.
![excel vba on error does not work excel 2016 excel vba on error does not work excel 2016](https://www.techonthenet.com/excel/pivottbls/images/bottom10_2016_001.png)
option that you want under Security settings for Dynamic Data Exchange: disable dde excel 2016. I can run macros but a certain segment of my code is not executing. Re-open your Excel to verify if the problem is resolved. My problem is not that macros can't be run. If that fails, open the file on the PC where it does work and then try using Code Cleaner (on it to fix its VBA project. Try saving the file from the PC where it works as an xlsm file and try that file on the other PC. However the macro security in excel is medium and hence I can run macros. So your file contains some content the Excel version you are using does not like.