LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Find Contents of Cell (Macro) - Help me!


Hi,

Could anyone please help me with the following problem:

I want to write a macro that will find the contents of the cel
currently highlighted on another sheet. For example:

Dog
Cat
Sheep


the cell highlighted is cat, so i want to find cat on another sheet.
Another time it is sheep, so I want to find that.

I can't work out how to do this, so any help would be fantastic.

Thanks so much!

Wil

--
MrMerto
-----------------------------------------------------------------------
MrMerton's Profile: http://www.excelforum.com/member.php...fo&userid=1096
View this thread: http://www.excelforum.com/showthread.php?threadid=39866

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find contents of the last cell in a row OCONUS Excel Worksheet Functions 4 September 18th 06 09:37 PM
Macro to remove contents of cell and move all other contents up one row adw223 Excel Discussion (Misc queries) 1 July 1st 05 03:57 PM
Find cell contents in range Nigel Excel Discussion (Misc queries) 7 May 16th 05 01:15 PM
using worksheet name to find cell in table of contents. RogueSwan Excel Programming 4 April 28th 05 03:00 AM
How do I find the contents of a cell using the "ADDRESS" function. sweeney Excel Worksheet Functions 2 April 5th 05 03:23 AM


All times are GMT +1. The time now is 08:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"