Coping within a set of Rows

[AM5648]

Hello,

I'm wondering how to copy data in the next blank cell within a set of rows?

I know that this will copy data into the next blank cell of the entire column A

.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial

But I want constraint that to just a certain set of rows in that column

Thanks,

 

[dangelor]

Change the row number to the last row in that certain set of rows, i.e. if you only want to copy into rows 2 through 20, you would change the range to:

.Range("A20").End (xlUp).Offset(1).PasteSpecial

 

[AM5648]

Thanks!

What if I wanted it to be in between rows A20 through A40 but rows A1 through A19 are blank?

 

[dangelor]

There are many ways to do this, but without seeing your worksheet, the simplest way would be to temporarily put something in Range ("A19") and remove it when you're done.

Range("A19") = "Temp" 

... run code....

Range("A19").Clear