|
|
#2
01-07-2017, 08:15 AM
|
|||
|
|||
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need to change table to text so that both columns merge to form 1 line | jrasicmark | Word | 3 | 02-24-2015 07:28 AM |
| Want to change Macro to copy and paste data to new sheet | Vortex69 | Excel Programming | 0 | 12-23-2014 09:53 PM |
 Macro to copy specific columns in Excel from another spreadsheet
|
KD999 | Excel Programming | 1 | 07-20-2012 08:58 AM |
| quick replace, sort, change columns | userman | Excel | 1 | 05-01-2012 06:24 AM |
| If two geographical data match in two sheets, copy unique id/code found in one sheet | alliage | Excel | 1 | 09-01-2011 05:23 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode