In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11. There are two shortcuts that you can use Alt + F11 for the VBA Window and Alt + F8 to view macros. Select your work and the module. Your macro should be Sub Clear_cells() range (C1:C11").clearcontents End Sub. To test it, press Alt F11 and Alt F8. You can also do this for whole worksheets, but inserting the name of the worksheet before "range" in the macro.
Just updated your iPhone to iOS 18? You'll find a ton of hot new features for some of your most-used Apple apps. Dive in and see for yourself:
1 Comment
"Your macro should be Sub Clear_cells() range (C1:C11").clearcontents End Sub"
REALLY ?!
And no one sees anything WRONG with this ?
UNDERWHELMED !!
Share Your Thoughts