Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching a text
Hi, My purpose is to search a field in another worksheet, and copy it' adjacent field, and paste it next to my original worksheet field. Th problem is that I can automatically paste the search text in th "cells.find". I want to search what i copied from my original field and not "Help". Here is my macro code : Selection.Copy Sheets("Sheet2").Select Cells.Find(What:="Help", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext _ MatchCase:=False).Activate ActiveCell.Offset(0, 2).Range("A1").Select Application.CutCopyMode = False Selection.Copy Sheets("Sheet1").Select ActiveCell.Offset(0, 4).Range("A1").Select ActiveSheet.Paste End Su -- ylkie ----------------------------------------------------------------------- ylkien's Profile: http://www.excelforum.com/member.php...fo&userid=2898 View this thread: http://www.excelforum.com/showthread.php?threadid=48712 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching for text | Excel Worksheet Functions | |||
searching for text inside a text box | Charts and Charting in Excel | |||
Searching for text | Excel Discussion (Misc queries) | |||
help searching text | Excel Discussion (Misc queries) | |||
Searching text | Excel Programming |