Forum Discussion
Excel M365 Business Basic
As LeonPavesic mentioned, Microsoft 365 Business Basic only lets you use the online (browser) versions of Excel, Word etc.
These versions don't have VBA - you cannot create, nor run macros. That is only possible in the desktop version of Excel, Word etc. for Windows and Mac.
You'll need to subscribe to a different Microsoft 365 plan to be able to download the desktop applications. See Compare All Microsoft 365 Business Plans
Just clearing simple multiple cells
How to do that in M365 Business Basic - Excel
Range("A1:A100").Clear
I am looking for where to insert this code since when I press ALT+F11 no macro window that shows 😞
Hi gmj12345,
in Microsoft 365 Business Basic, which primarily provides the online (cloud) versions of Excel, you don't have access to the VBA (Visual Basic for Applications) editor or the ability to create and run VBA macros as you can in the desktop Excel version. So, you can't use VBA code to clear a range of cells as you described.
Instead, in the online Excel version, you can achieve the task using different methods:
Open your Excel file in Excel Online.
Select the range of cells you want to clear, for example, A1:A100.
Right-click on the selected range and choose "Clear Content" from the menu.
This action will remove the data from the chosen cells.
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.
If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
(LinkedIn)
