Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm getting a runtime error '13':
Type Mismatch The code is: Function UsageLog_1() ' Stores who and when on Sheet1, column C Sheets("UsageLog").Select If Range("C5600").End(xlUp).Row = 1 And Range("C5600").End(xlUp).Value = "" Then <===== This is the line which is highlighted for the error Range("C5600").End(xlUp).Value = "Last opened by " & Environ("username") & " at " & Now Exit Function End If Range("C5600").End(xlUp).Offset(1, 0).Value = "Last opened by " & Environ("username") & " at " & Now ThisWorkbook.Sheets("COVER").Activate End Function Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
naming tab macro error runtime error 1004 | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |