macro to find cell content in sheets and make sheet active

Chris Gidman Chris Gidman is offline

Junior Member

Posts: 1

Quote:

Originally Posted by Nigel

how do i do that then? will it let me view the actual sheet on demand? if i
am working with a specific po number, will it find the sheet and make it
active?

Nigel,

If you are using VBA, once you find the worksheet, you need to select it to make it appear. If sheetIndex is a variable containing the name or number of the worksheet, use this:

Sheets(sheetIndex).Select()

If you post your code, perhaps the forum can provide more detailed help.

Regards.

G

Last edited by Chris Gidman : June 26th 14 at 02:44 PM

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
In Excel, how do you make one whole sheet equal to another.	ryan	Excel Discussion (Misc queries)	2	August 31st 05 07:03 PM
Lookup values in multipul sheets and show value in another sheet	Kim	Excel Worksheet Functions	3	June 17th 05 01:56 PM
Copying multiple sheets from one book 2 another and undertake spec	Pank Mehta	Excel Discussion (Misc queries)	14	March 16th 05 04:41 PM
Linking sheets to a summary sheet in workbook	gambinijr	Excel Discussion (Misc queries)	4	December 16th 04 08:13 PM
i need to make the sheets name come from a cell	sam wildig	New Users to Excel	8	November 29th 04 02:26 PM

All times are GMT +1. The time now is 08:35 AM.

Menu

About Us