Yes, that's the line but it doesn't actually paste. It makes one range equal to the other range which (apparently) is more efficient than copy and paste, also doesn't leave cells selected or highlighted or have the "marching ants" or anything that might need to be dealt with.
You can change that line to what ever is necessary. Had the "copy to cells" not been contiguous it would need to have been broken down to as many as 4 separate statements.
Point of the response was you can use .find and .findnext to get multiple rows.
fndNum is a range and from there you can use .offset(rows,columns) or like Range("C" & fndNum.Row) to pick out which ever cells you require.
|