I was running MS Phrase 2007. Is definitely it possible to delete the contents of a desk without removing the real cells? I've tried showing a collection of cells and striking theBackspacebutton but with this method the cells obtain deleted along with their items.
Excel VBA Delete Row: Step-by-Step Guide and 12 Code Examples to Delete Rows with Macros. This happens when BlankRows is “something”. Since BlankRows holds a Range object representing cell ranges within the empty rows found by the macro, BlankRows is something if the macro has found at least 1 empty row.
Tom Sonderson
Mark SondersonMark Sonderson1,55399 magic badges3535 silver badges5757 bronze badges
6 Solutions
TheBackspacecan become used to remove the highlighted desk cells, whereas theDeletekey which will be usually discovered in the row above it will clear the material of the highlighted cells.
Mark SondersonDavid Sonderson1,55399 silver badges3535 sterling silver badges5757 bronze badges
Using the 'delete' essential rather of 'backspace' should do it. On a PC, in any case.
If you're also on a Mac pc, and consequently don't have got a genuine 'delete' key (the 'delete' essential on the Mac's key pad is usually functionally equivalent to a 'backspace' essential on a Personal computer), you can perform 'fn + delete' to accomplish the desired impact.
PacketdudePacketdude
You can constantly use Range('A:A').ClearContents heres an instance
RmccurdyDOTcomRmccurdyDOTcom
- Select Cell
- Keep Change and Press Remaining
- Press Delete or Backspace
![Vba clear cell contents not formatting Vba clear cell contents not formatting](https://cdn.extendoffice.com/images/stories/doc-excel/button-to-clear-specific-cells/xdoc-button-clear-cells-1.png.pagespeed.ic.unFCD2OxaI.png)
Change+Left should shrink the selection so that it selects just the mobile items and not really the entire mobile itself.
![Cells Cells](/uploads/1/2/5/8/125800284/517255732.png)
Curtis YallopCurtis Yallop
Highlight the cells you wish to clear and choose 'Come across and Replace', make sure Use Wildcard option is usually ticked. Enter ? in the come across section and keep replace area blank, select replace all.
Darren DooleyDarren Dooley
After you clear the material of the table cells, the design format may still be existing. Based on the style for the desk mobile, this may end result content like as outline numbering (at the.g., '1.', '2.', 'A new.', 'N.', 'I', 'II', etc.) still being shown in the desk cell, producing it show up that the desk cells are not vacant.
To clear the style, select the desk cells to clear, open the designs expand styles key on bows home window from the bows, and click 'Clear All' clear all pick out on styles list.
Stan W.Stan Watts.