Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find a value in a row
Without moving the cursor from the active cell, I need a
code that will search across Row 1 in Sheet2 and find the one value that will match the value in Sheet1 A1 and copy that column. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find a value in a row
Hi JImmy
Why not return to the activecell after you perform your copy action. With application screenupdating off you unlikely to see any movement at all. BEst N10 "jimmyjohn" wrote in message ... Without moving the cursor from the active cell, I need a code that will search across Row 1 in Sheet2 and find the one value that will match the value in Sheet1 A1 and copy that column. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.764 / Virus Database: 511 - Release Date: 15/09/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
'find' somtimes can't find numbers. I folowd the 'help' instructi. | Excel Worksheet Functions | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
backwards find function to find character in a string of text | Excel Programming |