Clear UsedRange except specific cells?

Posted to microsoft.public.excel.programming

Ray

external usenet poster

Posts: 267

Clear UsedRange except specific cells?

A-HA! Figured it out ... the 'set rp...' line should read like this:

Set rp = ActiveSheet.Range("A4:C4")

NOW it works ...!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
clear specific cells in a form	vdmbqb	Excel Discussion (Misc queries)	1	November 24th 07 08:07 PM
Is there a formula to clear the contents of a specific cell?	Bob Smith	Excel Worksheet Functions	2	December 9th 06 07:41 PM
How do I clear a column of data without clearing specific cells?	EllenSwarts	Excel Discussion (Misc queries)	2	April 5th 06 05:07 PM
UsedRange & Formatting of Cells	JStone0218	Excel Programming	3	October 26th 03 11:36 PM
Using UsedRange as limits in a For Each loop but for cells on another sheet ?	tur13o	Excel Programming	2	October 23rd 03 01:18 PM

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

About Us