Selecting a "found" range

[skrimpy]

I have a loop that looks through a large column of data. When the loop finds specific data I need it to copy this row and the next row for six columns, and then paste it to another point on the page. I know how to code copy and paste but I'm not quite sure how to select the appropriate range without specifying which cells. For example, I need to select "A1:B:6" if A1 contains the data I'm looking for, or "C1:D6", if C1 contains the data I'm looking for. Can anyone help? Thanks.

[tony h]

try
selection.resize(6,2).select

or use a range object for cleaner coding