phanikumar.bs
New Member
I am facing a problem while running a Macro, the userforums.show is not working.
My code :-
'Clears the invoice sheet
Private Sub CmdNewInv_Click()
With Sheet2
'Clear previous invoice details
[D15:H16, D17:H17, F18:H18, C20:D20, G25:H27, H13, G20:H20, B25:D27, A34:D34, E34, E40, A42:H42].ClearContents
'INCREMENT THE INVOICE NUMBER
[C13] = [C13] + 1
'open userform
frmNewInv.Show
End With
End Sub
Please help me as i was not able to find out whats the problem.
If you require any more information please let me know.
My code :-
'Clears the invoice sheet
Private Sub CmdNewInv_Click()
With Sheet2
'Clear previous invoice details
[D15:H16, D17:H17, F18:H18, C20:D20, G25:H27, H13, G20:H20, B25:D27, A34:D34, E34, E40, A42:H42].ClearContents
'INCREMENT THE INVOICE NUMBER
[C13] = [C13] + 1
'open userform
frmNewInv.Show
End With
End Sub
Please help me as i was not able to find out whats the problem.
If you require any more information please let me know.