3/10/2023 0 Comments Excel 2016 for mac cell nameWhen I enter a value and press tab in Excel 2016, I get the runtime error 91 "Object variable or With block variable not set". Sheets("sheet1").Protect, UserInterFaceOnly:=TrueĬells(6, i).Value = Cells(6, i).Value + Cells(15, i).Value If Intersect(Target, Range("C15:H15")) > 0 Then This is the script: Private Sub Worksheet_Change(ByVal Target As Range) Now, I have installed Excel for Mac 2016 and all of a sudden, the macro doesn't work anymore. Initially, I developed and used it in Excel 2013, then I have switched to Mac and have since used it in Excel for Mac 2011. I have developed a small VBA macro in Excel that's supposed to add the values of cells in row 15 to the values of cells in row 6 during workbook change (in my case entering a number in row 15 and pressing tab).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |