View Single Post
 
Old 05-10-2015, 08:42 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 32bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

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.
Reply With Quote