|
本帖最后由 diudiu422 于 2015-12-15 11:16 编辑
- Private Sub 清空_Click()
- Dim c As Object, fadd As String, No As String, b As String
- b = Format(Now, "yymmdd")
-
- Range("C4:E4,B6:H15,C18,E18,H18,J18,j6:j16").ClearContents
- With Sheets("入库明细表").Range("B6:B" & Sheets("入库明细表").[B65536].End(xlUp).Row)
- Set c = .Find(Left(Range("J2"), 6), LookIn:=xlValues, lookat:=xlPart)
-
- If b = Mid(c, 5, 6) Then
- fadd = c.Address
- Do
- No = Left(c, 4) & Format(CStr(Mid(c, 5) + 1))
- Set c = .FindNext(c)
- Loop While Not c Is Nothing And c.Address <> fadd
- Else
- No = "CPRK" & Format(CStr(Now), "yymmdd") & "01"
- End If
- End With
- Range("J2") = No
- End Sub
复制代码 If b = Mid(c, 5, 6) Then 这句一直报错,怎么改都不对,求人来帮看看,本人小白
附件附上,入库 那个工作表的代码
把原有的:If b = Mid(c, 5, 6) Then改成
if c is nothing then tmp="" else tmp=Mid(c, 5, 6)
If b = tmp Then
|
|