RangeObject.Delete method question

  • Thread starter Thread starter Frederick Chow
  • Start date Start date
F

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.
 
Hope this helps:

vntTemp = Sheet1.Range("F6")
Sheet1.Range("F6").ClearContents
'Following would move up 1
Sheet1.Range("F6").Offset(-1, 0) = vntTemp
 
ImpulseBlue said:
Hope this helps:

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