View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Macro to insert copied cells

You can always adjust this line:

For RowNdx = EndRow + 1 To StartRow + 1 Step -1
to
For RowNdx = EndRow + 1 To StartRow Step -1

to get the first row.

wrote:

Hi Dave,

The second one seems to work (the first missed out the 1st row)

Any everyone, thanks for all of your help.

Hopefully this will help someone else too someday :)

Thanks again,

Rich


--

Dave Peterson