Seems to be working OK in Excel 2016 for Mac Build 15.26. Aug 25th, 2016, 10:34 AM. Re: VBA Worksheet.Select REPLACE argument not working on Office 2016. Hi wiz329 I have the exact same problem in Excel 2013. It worked before on my computer, it still works on my colleague computer with both Excel 2013 and 2016. This doesn't seem.

Hello all, I am using excel 2016 in mac. I've created a macro which reads some data from an another excel file and do some math after closing a input file. My xlsm file is running fine in mac 2011, but in 2016 scrollarea property and workbook.close is not working. I tried to lock my sheet in workbook open. Following the code used To scrollarea: Private Sub Workbook_Open() Sheets('Total').ScrollArea = Range('A1:T50').address End Sub To close: #if mac then workbook('filename.xlsx').close false #end if Please anyone help me to solve this!!! Thanks in Advance.

Stop sending Mac Excel users to other forums. THIS is the correct forum for VBA problems with Excel for Mac.

99% of the time all they're going to do in that other forum is refer the person right back to this forum, which is the correct one in the first place. Not only that, you made it look like you answered the person's question, which you did not. So now I have to do do it for you and that's extra, unnecessarily work for me. I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft.

'Microsoft Agents' work for Microsoft Support. Hi Pooja I tested ScrollArea in Excel version 15.28 and am able to reproduce that the command does not work as expected. I reported this to Microsoft.

You should also report this problem to Microsoft by using the Smile button in Excel. I tested Close and found that it is working in Excel 2016. You have a syntax error. You left out the letter s.

Proper syntax is: #if mac then workbook s('filename.xlsx').close savechanges:=false #end if I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support.