RangeObject.Delete method question
 

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.

RangeObject.Delete method question
 

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.

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.