Menu

Search all worksheets

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Dave Peterson Dave Peterson is offline

Dave Peterson is offline

external usenet poster

Posts: 35,218

Default

Search all worksheets

Check your other post, too.

wrote:

Hey, I have a workbook with many worksheets. I am trying to write a
macro to search all the worksheets for a unique value. I have a
userform to enter the value and assign it to a variable. I just need
to search all sheet for that string, and if that string exists in a
worksheet, activate that worksheet. Anyone done anything like this?
Can you help?

--

Dave Peterson

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
search for a particular cell in worksheets	JoviGirl	Excel Worksheet Functions	2	January 14th 09 11:45 PM
search over range of worksheets	Kanga 85	Excel Programming	2	May 9th 06 01:28 PM
Search in Multiple Worksheets	Lizz45ie	Excel Discussion (Misc queries)	0	October 19th 05 05:22 PM
search worksheets	Anthony	Excel Discussion (Misc queries)	11	July 14th 05 03:24 PM
Search Multiple Worksheets	jtinne	Excel Discussion (Misc queries)	4	February 3rd 05 07:26 PM

All times are GMT +1. The time now is 09:47 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement