RangeObject.Delete method question

[Frederick Chow]

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.

 

[ImpulseBlue]

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]

Hope this helps:

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