Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Application.WorksheetFunction.Match on a sheet that isn't active
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Application.WorksheetFunction.Match on a sheet that isn't active
Resolved · High Priority · Version 2003
Reply
Application.WorksheetFunction.Match on a sheet that isn't active
I want to use Application.WorksheetFunction.Match on a sheet that isn't active. Can this be done?For upcoming training course dates see: Pricing & availability
RE: Application.WorksheetFunction.Match on a sheet that isn't ac
Hi JamesThank you for your question.
Yes you can use match onto another sheet. For the second argument, the range, you need to specify the sheet first and then the range.
Example
Application.WorksheetFunction.Match(1, Sheets("Sheet1").Range("A1:a10"))Please let me know how you get on.
Laura GB
Thu 27 Nov 2008: Automatically marked as resolved.
|
 |
|
» Forum post: Setting up a company Intranet |
How can I set up a webpage for company employees to access documentation on the website but which is protected from other web-users. E.g a password access??
