98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Application.WorksheetFunction.Match on a sheet that isn't active
Application.WorksheetFunction.Match on a sheet that isn't active
Resolved · High Priority · Version 2003
Tue 18 Nov 2008, 12:59Delegate James said...
James has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
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?
Fri 21 Nov 2008, 13:27Trainer Laura said...
RE: Application.WorksheetFunction.Match on a sheet that isn't ac
Hi James
Thank 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.
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. |
Excel tip:Create a unique items table from a duplicating table1. Ensure that your list has column headings |
