Need help with this project - Deadlines Suck!!

Posted by Kevin Mac on December 21, 2001 12:29 PM

: I forgot to mention that all the cells in Column D calculate correctly and display correctly, until a change is made in Column A, and the date/time stamp is placed in Column R. This is when I get the #VALUE in Column D. Hope this helps you guru's help this Rookie!!!

Posted by Ivan F Moala on December 21, 2001 12:53 PM

Take out the XlParamaterDataType & " "

Posted by Ivan F Moala on December 21, 2001 1:06 PM

Just a side note on username

I note you are using the Application.username
This is taken from the Tools | Option |General
UserName input so if the user fills this in with
nothing or any other Name this is what you will get.
You can get the users Reg name OR NTUsername if
you wanted.

Declare Function WNetGetUser Lib "mpr.dll" Alias "WNetGetUserA" _
(ByVal lpName As String, ByVal lpUserName As String, lpnLength As Long) As Long

Function GetName() As String
Dim strUserName As String
strUserName = Space(255)
WNetGetUser "", strUserName, 255
GetName = Trim(strUserName)
End Function

Ivan

Posted by Kevin Mac - thanks for the assist again!!! on December 21, 2001 1:20 PM

Re: Just a side note on username