Reference a User Name via macro
 

What code should I use to reference the current user that is saved within
Excel. When the macro is run, in A2 I would like it to display the user
that ran the macro

Range("A2").Value = current user name

Thanks,
Paul

Reference a User Name via macro
 

Range("A2").Value = environ("username")

or perhaps you are looking for application.Username which is what is entered
in Tools=Options=General tab

--
Regards,
Tom Ogilvy


"PCLIVE" wrote in message
...
What code should I use to reference the current user that is saved within
Excel. When the macro is run, in A2 I would like it to display the user
that ran the macro

Range("A2").Value = current user name

Thanks,
Paul

Reference a User Name via macro
 

Range("A2").Value = Environ("UserName")
should work



"PCLIVE" wrote:

What code should I use to reference the current user that is saved within
Excel. When the macro is run, in A2 I would like it to display the user
that ran the macro

Range("A2").Value = current user name

Thanks,
Paul

Reference a User Name via macro
 

Tom,

Thank you. You have covered both areas, one of which I will definitely use.
After testing each method you've suggested, I will most likely use
environ("Username"). After testing this I'm assuming that this is pulling
from the "Computer Name" set in Device Manager.

Thanks again for your help.
Paul


"Tom Ogilvy" wrote in message
...
Range("A2").Value = environ("username")

or perhaps you are looking for application.Username which is what is
entered
in Tools=Options=General tab

--
Regards,
Tom Ogilvy


"PCLIVE" wrote in message
...
What code should I use to reference the current user that is saved within
Excel. When the macro is run, in A2 I would like it to display the user
that ran the macro

Range("A2").Value = current user name

Thanks,
Paul