de-select the whole sheet

[lezawang]

Hi
I can select the hole sheet by clicking on the icon on top left corner. How can I deselect a sheet with out clicking on any cell? the reason I want to know because I am recording macro that will select and delete the whole sheet then deselect.

Thank you

 

[Joe4]

I don't think you can be on a sheet and not have at least one cell selected.
The default typically is A1.
If you want to totally de-select, move to another sheet.

Why do you think you need to totally de-select anyway?

 

[lezawang]

I want to create a control button to clear the content of all sheet. So I recorded a macro, selected the whole sheet, then click on Delete, then ??? here I want to deselect and stop recording. Thank you so much.

 

[Joe4]

This is the only line of VBA code you need to clear all the contents from the active sheet. No need to select or de-select anything.

    Cells.ClearContents

 

[lezawang]

That is right but I am still not familiar with VBA, so I want to get the code from recording the Macro. Time to learn VBA I guess thank you so much

 

[Joe4]

The Macro Recorder is a great tool, especially for beginners. But there are a few things to keep in mind using it:
- there are certain functions/commands it cannot record (i.e. you can record a "loop")
- it is very literal (with "Selects" and "Scrolls", so some clean-up may be necessary to make your code efficient)
- it may not always record the most efficient ways of doing things (basically, it just records whatever you are doing manually)