Paste row in first free row in Range.

Hello,

I want to paste a row in the first free row in a range. The first row can be empty.
I try the code

Destination:=Worksheets(strHelp).Range("A101:A200").End(xlDown).Offset(1, 0)

But this is not working.

Can somebody help?

aisietie

Re: Paste row in first free row in Range.

Thanks for the quick reply,
but I want to paste the row in the first free row in the range between A101 and A200 starting in A101
It is possible that the first row 101 is emty, and then the row must be pasted in row 101

aisietie

Re: Paste row in first free row in Range.

Dave, Jindon,

Thanks.
With the code SpecialCells(4)(1) it works perfect.

aisietie