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 😞
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
- So the only option is manual clearing.. SAD 😞
Thank you all