Conversion of excel function to vba code

xiaowang

Beginner

Points

290

Posts

34
Feb 23rd 2020
- #1
hi all i would like to convert this excel function =ADDRESS(MATCH(T1,A:A,0),1) to a vba code would that be possible please do advise!
rory

Some guy

Reactions Received

133

Points

16,703

Posts

3,304

Operating System

Windows (x64)

Excel Version

Office 365
Feb 24th 2020
- #2
May I ask why?
Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why
royUK

Super Moderator

Reactions Received

809

Points

133,284

Posts

26,393

Operating System

Windows (x64)

Excel Version

Office 365
Feb 24th 2020
- #3
An inbuilt function like Match will always be more efficient than the best effort at a VBA Function
Hope that Helps

Roy

New users should read the Forum Rules before posting

For free Excel tools & articles visit my web site

Check out my new web site.

royUK's Database Form

Where to paste code from the Forum

About me.
Carim

OzMVP (0007*2) - 4

Reactions Received

1,006

Points

37,921

Posts

7,360

Operating System

Windows (x64)

Excel Version

Excel 2019
Feb 24th 2020
- #4
Hi,

Seems to me you have already asked a question pretty close ... about Match ...

How to prevent the error of Unable to get the Match Property of the WorksheetFunction class error?
If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login

Share

Users Viewing This Thread

1 Guest

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.