find a value in a row

  • Thread starter Thread starter jimmyjohn
  • Start date Start date
J

jimmyjohn

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I send an email too? 3
My Never ending ARRAY code problems 18
Match columns to rows then loop. 2
Changing Cell Color based upon value on another worksheet 2
Transfer array element offset value to a matched value 3
Compating all rows in two sheets 2
Excel VBA help: Text file formatting 19
Find the correct sheet then find a value on that sheet 8

Back
Top