Posted to microsoft.public.excel.programming

John[_94_] John[_94_] is offline

external usenet poster

Posts: 19

Debug Problem

Clearing worksheets also clears the formulas. So does delete. How can I
clear a worksheets without destroying the formulas in the worksheet.

I run macro, edit it then want to run again but with the worksheets
cleared. When I clear them, I have to reenter all the formulas.

JOhn

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
DeBug	Ollie	Excel Discussion (Misc queries)	4	April 28th 06 03:17 PM
help with debug	Jim May	Excel Programming	2	August 10th 04 01:04 PM
No debug box	mushy_peas[_33_]	Excel Programming	2	April 23rd 04 12:20 AM
Debug problem	James L[_3_]	Excel Programming	3	April 7th 04 01:32 PM
debug help	Tom Ogilvy	Excel Programming	0	August 27th 03 07:10 PM

All times are GMT +1. The time now is 12:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us