Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime Error
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime Error
What's in cell C1? I also get a type mismatch if I've got #N/A in C1, for
instance. If it's blank or alphanumeric, this seems okay. "CurtH" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime Error
C1 is filled with: Last opened by chasan at 12/27/2005 3:43:08 PM
The log is suppose to annotate who accesses the files upon exiting the file. So, the log move to the next blank line and enters the data. "CurtH" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime Error
When the error occurs, what row has been selected by the end(xlUp)? In the
immediate window, what is the result of print range("c5600").End(xlUp).Row? And what is in column C of that row? Even if the first condition of the AND fails, Excel likes to evaluate the second condition, so an error in that cell would also cause problems. "CurtH" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime Error
Thanks! You got me to think and figured it out.
"bpeltzer" wrote: When the error occurs, what row has been selected by the end(xlUp)? In the immediate window, what is the result of print range("c5600").End(xlUp).Row? And what is in column C of that row? Even if the first condition of the AND fails, Excel likes to evaluate the second condition, so an error in that cell would also cause problems. "CurtH" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |