Find Range for Pasting of Records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kou Vang - 25 Jan 2006 18:45 GMT

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?

Reply to this Message

Toppers - 25 Jan 2006 21:58 GMT

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

> 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
[quoted text clipped - 9 lines]
> I would have to count column "D" and find the corresponding last row with
> data correct?

Reply to this Message