Posted to microsoft.public.excel.programming

external usenet poster

Posts: 15

Clear Contents Macro

I have a workbook with six worksheets. On Sheet 6, I want to create a macro
linked to an Excel button from the forms toolbar. I want the macro to only
clear the contents of Sheet 1, Sheet 2, Sheet 3, Sheet 4, and Sheet 5 in the
following cells C7, C9, C16:C23, and C26:C33. I am trying to write a code
that will do this, any thoughts?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to clear contents and put an X	bevchapman	Excel Discussion (Misc queries)	3	March 17th 09 07:03 PM
Macro to clear range contents when cell contents are changed by us	Steve E	Excel Programming	12	February 22nd 07 09:09 PM
Clear Contents Macro	WBTKbeezy	Excel Programming	1	November 16th 06 10:50 PM
Clear contents macro	Dave	Excel Programming	10	April 6th 06 07:41 PM
Need macro to clear contents	steve_sr2[_2_]	Excel Programming	4	February 28th 06 09:20 AM

All times are GMT +1. The time now is 08:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us