Thread: How to Insert Rows but not Ripple up others
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta[_3_] Tushar Mehta[_3_] is offline
external usenet poster
  
Posts: 37
Default How to Insert Rows but not Ripple up others
In article ,
says...
Hi all,

From A100 to A200, I need to insert rows , but I do not want to push other
rows below A200 down. I know code can do it, but is there a hack here?

Clara

thank you so much for your help

It would appear that you want to clear the contents of A100:A200. If
so, select the range and press the DEL (i.e., Delete) key.
Reply With QuoteReply With Quote