software

I have data sheets which I fill out annually. The outline stays the same;
however, the data fields change. Is there a way I can clear all of the data
fields with a couple of keystrokes.

Make a non-contiguious Range of all the cells you wish to empty, named
YourDataInput.....(hold down Ctrl while maually clicking on each cell to be
emptied, then Insert gt; Name gt; Define, and type YourDataInput in the upper
window), then put this code in a regular module and run it....

Sub ClearYourDataInput()
Range(quot;YourDataInputquot;).ClearContents
End Sub

Vaya con Dios,
Chuck, CABGx3quot;Electrical Wizardquot; lt;Electrical gt; wrote in
message ...
gt; I have data sheets which I fill out annually. The outline stays the same;
gt; however, the data fields change. Is there a way I can clear all of the
data
gt; fields with a couple of keystrokes.
F5gt;Specialgt;Constants. De-select what you don't want to be selected then OK.

Editgt;Clear Contents.

That's more than a couple of key strokes, but you could turn on the macro
recorder while doing the above.

Assign the macro to a shortcut key combo and you're good to go.Gord Dibben MS Excel MVP

On Tue, 10 Jan 2006 15:14:03 -0800, quot;Electrical Wizardquot; lt;Electrical
gt; wrote:

gt;I have data sheets which I fill out annually. The outline stays the same;
gt;however, the data fields change. Is there a way I can clear all of the data
gt;fields with a couple of keystrokes.