Find Range for Pasting of Records

[Kou Vang]

I am pasting data into inserted columns. How do I figure out the range of
the records that I have so I know when to stop pasting down the new inserted
columns?

A B C D E
x x
x x
x x
x x
x x

I would have to count column "D" and find the corresponding last row with
data correct?

[Toppers]

lastrow=Cells(rows.count,"D").End(xlup).row will give you the last row in
column D

"Kou Vang" wrote:

> I am pasting data into inserted columns. How do I figure out the range of
> the records that I have so I know when to stop pasting down the new inserted
> columns?
>
> A B C D E
> x x
> x x
> x x
> x x
> x x
>
> I would have to count column "D" and find the corresponding last row with
> data correct?