View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
D[_2_] D[_2_] is offline
external usenet poster
 
Posts: 5
Default Auto Increment Rows in between numbers

Hello.
I have a spreadsheet that has a list of numbers on the left side (Column A)
and I need to know how to create a macro that when I hit a button a row will
insert in between the list of numbers and automatically fill in the number
that goes there. If that makes sense. So if I have a list of 1-20 and I
insert a row between 15 and 16, it will put 16 in that cell and put 21 at the
end of the list. Thanks so much for you help.
--
D