View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] geofferrington@hotmail.com is offline
external usenet poster
 
Posts: 25
Default Configuring Double Click

Norman

What I am trying to achieve is a macro that selects all the data in
colmns B,C,D and E, below the row where the "Cursor" is, and move it
all down 1 row.

Much the same as we do manually when we make a selection and then drag
just that selection to somewhere else on a sheet.

I need to do this because XL has problems (or, more likely, myself)
inserting a row in a locked (protected) environment.

I will write a separate routine for inserting spaces later. That part
is not very important at the moment.

Norman you are a very patient man.

Geoff