Thread
:
change 'Found.EntireRow.Copy' to a # of columns
View Single Post
01-07-2017, 08:15 AM
NoSparks
Windows 7 64bit
Office 2010 64bit
Excel Hobbyist
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
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
NoSparks
View Public Profile
Find all posts by NoSparks