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