Home |
Search |
Today's Posts |
#23
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Jerry,
You have "sFind" in your code twice. The second time it is assigning the value in cell A1 (which is just the number, not the text). Does your message box display the correct name? If so, simply delete this line from your code: sFind = ThisWorkbook.Sheets("Home").Range("A1").Value Ben |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I export a row of data into its own workbook | Excel Worksheet Functions | |||
How do I export data from a workbook to an email | Excel Discussion (Misc queries) | |||
import/export data from a workbook | Excel Discussion (Misc queries) | |||
How to export data to a closed Workbook | Excel Programming | |||
Create workbook for data export and then data import? | Excel Programming |