Services: Virtual Lab (Lab Anywhere) Last updated Wednesday, Sept. 26, 2018, at 12:34 p.m. Virtual Lab (Lab Anywhere) makes University-supported software available to students, faculty, and staff on their personal computers and tablets.
Hi Am I missing something? I've been periodically using the Excel 2016 for Mac updates but quickly abandoned them because my sheets rely so heavily on VBA and support for that seemed to be missing. I've updatd to the production version today (15.2).and it still seems to be the case? The Visual Basic editor is.ahem.extremely basic with no menus, right click functions or anything. No ability to insert new modules either. Shortcuts don't work (breakpoint, run etc).
What's going on? Please tell me there's some security setting i need to switch or something.please tell me there's basically no way to create macros enabled spreadsheets in Office for Mac 2016?
![Excel virtual lab for mac pc Excel virtual lab for mac pc](https://help.unc.edu/files/2012/04/VirtualLabSetup_SS3-Detect-Receiver.png)
On the off chance that your data is not always filled across your three rows (that is, as an example, Column B could have the last piece of data in it while the cells in Columns A and C next to it are blank), then you will need a more general method. The following line of code will find the last used cell no matter what column it is in. ActiveSheet.Cells.Find(What:='.' , SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Select. PLEASE READ. If this response answers your question, please mark it as the 'Answer'.