View Single Post
 
Old 01-07-2017, 08:15 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 779
NoSparks has a spectacular aura aboutNoSparks has a spectacular aura aboutNoSparks has a spectacular aura about
Default

Actually 'myText' is the search string you're looking for.
Found is the single cell range where it's found, from which you get the row.

You need to specify the range to copy, something like
Code:
Range("B" & Found.Row & ":K" & Found.Row).Copy
Reply With Quote