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?