View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
alan_stew alan_stew is offline
external usenet poster
 
Posts: 9
Default Macro To Move Cell Over

Brazen,
How about this?
Save this function in your personal.xls, create a button to trigger it
( like you said in your first post)
and you've got it!

Function MoveIt()
intAnswer = InputBox("Move over how many cells, 1 or 2?")
With ActiveCell
.Offset(0, intAnswer).Value = .Value
.Value = ""
End With
End Function

Of course, by now, you could have done the whole list by hand!!! ; )
Alan