Add this code to a standard module in your project. You can then just add the
formula =loginid() to the cell that you want to display the user name...

public function LoginId() as string
application.volatile
LoginID = Environ("UserName")
end function
--
HTH...

Jim Thomlinson


"Kalpana_Kar" wrote:

I am in need of some function or macro to populate a column in an excel
spreadsheet for existing rows with the user's network login id.