Posted to microsoft.public.excel.programming

Frederick Chow Frederick Chow is offline

external usenet poster

Posts: 75

Thanks for your advice (N/C)

"ImpulseBlue" wrote in message
ups.com...

Hope this helps:

vntTemp = Sheet1.Range("F6")
Sheet1.Range("F6").ClearContents
'Following would move up 1
Sheet1.Range("F6").Offset(-1, 0) = vntTemp

Frederick Chow wrote:
Hi all,

RangeObject.Delete method will delete the existing range and shift the
remaining contents upward or leftward. I would like to find some means of
clear the content of the range and move the contents (not formats) upward
or
leftward. Any ideas? Thanks a lot.

Frederick Chow
Hong Kong.

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
Alternative copy/delete method needed	KevHardy	Excel Discussion (Misc queries)	2	February 11th 10 01:39 PM
Delete method of Range class failed	dan_coder	Excel Programming	1	July 24th 06 10:16 AM
Delete method	chessley	Excel Programming	2	February 4th 05 07:43 PM
Delete method of Range class failed - HELP!!!	richilli	Excel Programming	1	October 20th 04 06:24 PM
Range.delete method	Touk	Excel Programming	1	September 28th 04 06:15 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us