View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff[_23_] Jeff[_23_] is offline
external usenet poster
 
Posts: 2
Default Insert new row after hitting enter

I would like to write VBA code that basically inserts a
row in a range after someone fills in a cell and hits
enter. For example, if my range is row1:row4, and someone
enters data in row1, a new row is inserted for row2 after
entry. I have created a a worksheet that is sectioned of
into several categories and I do not want to show
numberous rows unless data entry is required -- i.e., the
section grows the more rows someone enters. Any help is
appreciated.