Thread: How do I insert a row below the active row?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Glen Mettler[_4_] Glen Mettler[_4_] is offline
external usenet poster
  
Posts: 70
Default How do I insert a row below the active row?
Here is one way:

Row = Selection.Row()
Cells(Row + 1, 1).Select
Selection.EntireRow.insert

"M. Higginbottom" <M. wrote in
message ...
I want to enter data via a macro which is currently working but inserting a
new row moves the new entry dow so lists are built from the bottom up
rather
than top down.


Reply With QuoteReply With Quote