Thread: Move cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wild Bill[_2_] Wild Bill[_2_] is offline
external usenet poster
 
Posts: 90
Default 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