本帖最后由 爱疯 于 2014-10-31 16:51 编辑
各位,公司的前辈留下一个表格,运行某项功能时出现 【运行时错误 ' 13':类型不匹配】,我刚接触EXCEL VBA编程,实在是搞不定,还求各位指教,谢谢!代码如下(黄色部分文字为出错的地方):- Function read_lastendtime()
- For i = 9 To Cells(9, 1).CurrentRegion.Rows.Count
- hc = ""
- shipname = trim_(Cells(i, 1), hc)
- If InStr(hc, "V") > 0 Then
- hc = Val(Right(hc, 2))
- line_ = 6
- lastday = ""
- Do While Sheets("外贸结算").Cells(line_, 1) <> shipname And Sheets("外贸结算").Cells(line_, 1) <> "": line_ = line_ + 1: Loop
- Do While Sheets("外贸结算").Cells(line_, 1) = shipname And Sheets("外贸结算").Cells(line_, 1) <> ""
- If lastday < Sheets("外贸结算").Cells(line_, 8) Then lastday = Sheets("外贸结算").Cells(line_, 8): line_lastday = line_
- line_ = line_ + 1
- Loop
- <b><font color="#ff8c00"> bugetday = DateValue(Year(Now) & "-" & Cells(1, "R") & "-1 0:00")</font></b>
- If Now() - bugetday > 300 Then
- bugetday = DateValue(Year(Now) + 1 & "-" & Cells(1, "R") & "-1 0:00")
- End If
- If lastday <> "" And Val(Right(Sheets("外贸结算").Cells(line_lastday, 4), 2)) + 1 = Val(Replace(hc, "V", "")) Then Cells(i, "N") = bugetday - DateValue(lastday)
- End If
- Next
- End Function
复制代码
Cells(1, "R"),看看过个单元格里是什么。
|