Hi I have below code thanks to Alphafrog, which works brilliant I need to insert a msg if some criteria is is not full filled.
Below is the working code and I need to insert this criteria.
Please have a look and see if you can help
Sincerely
Abjac
Creteria to be inserted in the code is
Here is the code I would like to merge this criteria with.![]()
If .Cells(i, "A") = "758" And .Cells(i, "B") = "03" And .Cells(i, "P") = "" Then . MsgBox "You need to insert the account name for country code 758 ledger 03" Exit sub
![]()
Sub alphafrog() Dim i As Long, j As Long, arrEQ As Variant, iCell As Range 'Number of Dots in cells E to Q arrEQ = Array(5, 8, 12, 2, 6, 6, 1, 1, 3, 11, 42, 35, 6) Sheets("Robot").Activate With Sheets("Robot") For i = 3 To .Cells(.Rows.Count, "A").End(xlUp).Row If WorksheetFunction.CountBlank(.Range("A" & i & ":AQ" & i)) <> 43 Then '32 dots in cell R If .Cells(i, "A") <> "" And .Cells(i, "B") = "03" Then With .Cells(i, "R") .Value = .Value & String(Application.Max(32 - Len(.Value), 0), ".") End With End If 'Cells E:Q (number of dots defined in arrEQ) For j = 0 To 12 With .Cells(i, "E").Offset(, j) .Value = .Value & String(Application.Max(arrEQ(j) - Len(.Value), 0), ".") End With Next j '3 dots in cells S:AQ For Each iCell In .Range("S" & i & ":AQ" & i) iCell = iCell & String(Application.Max(3 - Len(iCell), 0), ".") Next iCell End If Next i End With End Sub











LinkBack URL
About LinkBacks
Register To Reply
多么想要告诉你 我好喜欢你
Bookmarks