Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Find
Hi. I am relatively new to VB ...
Part of my subroutine needs to accomplish the following: 1. Copy the activecell in file1 to memory. 2. Go to file2 (already open) and search for and find the same value. 3. Move down 1 cell from that location Any help? Thanks, Mike. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Find
Try this:
Memory1 = ActiveCell.Value Workbooks(file2).Activate Cells.Find(What:=Memory1, After:=ActiveCell, _ LookIn:= xlValues, LookAt:=xlPart, _ SearchOrder:=xlByRows).Select ActiveCell.Offset(1,0).Select You may want to change xlValues to xlFormulas if the Find does not work. You also may want to change xlPart to xlWhole if you start finding things that contain what you are looking for but are not exactly the item you want. -----Original Message----- Hi. I am relatively new to VB ... Part of my subroutine needs to accomplish the following: 1. Copy the activecell in file1 to memory. 2. Go to file2 (already open) and search for and find the same value. 3. Move down 1 cell from that location Any help? Thanks, Mike. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy contents of Find (Find and Replace) | Excel Discussion (Misc queries) | |||
Find in XML and Copy | Excel Discussion (Misc queries) | |||
Find and Copy | Excel Discussion (Misc queries) | |||
Find and Copy | Excel Discussion (Misc queries) | |||
Find and copy?? | Excel Worksheet Functions |