If you want to clear the cells with code -
Sub Clear_The_Cells()
Range("A100:A200").Select
Selection.ClearContents
End Sub
--
Best wishes,

Jim


"clara" wrote:

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