Posted to microsoft.public.excel.programming

Peter[_58_] Peter[_58_] is offline

external usenet poster

Posts: 8

Excel 97 clearcontents method fails

I have a spreadsheet written in 2003 with the following code

destcell.clearcontents

Where destcell is a valid range (consisting of a single cell).

This fails when running under excel 97.

I've tried

destcell.clear

but this fails as well.

Anybody recognise this behaviour?

Anybody know where I can find useful resources on what has changed?

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
Method 'SaveAs' fails	mtpsuresh[_3_]	Excel Programming	1	August 16th 06 11:21 AM
Activate method of Worksheet class fails in Excel 2000	Chris Bloom	Excel Discussion (Misc queries)	3	September 10th 05 12:05 AM
ClearContents method on a passed range	bryan	New Users to Excel	2	January 19th 05 08:49 AM
Excel 2002 SP2 VBA 6.3 'RefersTo' Method fails	Robert L. Porter	Excel Programming	2	June 4th 04 02:31 PM
Open method of workbooks fails when Excel is hosted in IE	[email protected]	Excel Programming	5	January 30th 04 02:19 AM

All times are GMT +1. The time now is 07:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us