View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default move around cells

Hi Folks

All I want to do is:
select a cell
activate cell
Go to start of cell
Highlight first five characters
Cut these characters
Move left to adjacent cell
paste characters to cell
Move down
Move right

I'm quite happy to use a keyboard control to activate the
macro each time I need it.

I can do this in recorder but the cell ranges are hard
coded. I need it to be local to the cell I am in. All
help much appreciated.

Joe