Show page name when function is complete.

  • I like the way this function works and I am looking for a way to show the page name when a match is found.


  • Re: Show page name when function is complete.


    Welcome to Ozgrid.


    Please use the correct tags when posting VBA code.
    I have replaced the HTML tags with code tags.


    That bit of code should have come from here: Vlookup Across Excel Worksheets
    It appears to be modified and returns an error.


    This revision will display a message box with the name of the sheet on which the value was found.


Participate now!

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