Move cells
Brilliant. At first glance my simple brain thought it would lose the
column width of the selection from the (,1) -- but of course it doesn't
since it operates on the offset, not the selection itself. Shrewd.
On Wed, 27 Aug 2003 08:59:10 -0400, "Tom Ogilvy"
wrote:
Selection.offset(0,-1).Resize(,1).Delete Shift:=xltoleft
selection.offset(0,-1).Select
may or may not be useful
|