Hi,

I need to move the values in a selection one cell to the right. Th
selection is not limited one one row or column and I don't want to mov
the formatting. I tried this (which as pseudo-code does what I want
but it gives an error because the PasteSpecial method doesn't work wit
Cut:

Code
-------------------

Selection.Cut
Selection.Offset(0, 1).Select
Selection.PasteSpecial xlPasteValues

-------------------

Any ideas? Thanks in advance for your help!

-Dann

--
Message posted from http://www.ExcelForum.com