Dilip Sir , aapki video dekh Kar ek vba project bnaya h , but usme error aa rha h , please help kro na 🙏
@thedatalabs2 жыл бұрын
Could you please share the code here? I will take a look and get back to you. Thanks!
@CHARANSINGH-lk5wb2 жыл бұрын
@@thedatalabs Sub Save() Dim sh As Worksheet Dim lRow As Long Dim mno As Integer ' mno for month mumber Dim mn As String ' mn for month name mno = Month(frmForm.txtdate.Value) 'extracting month number mn = MonthName(mno) 'extracting month name Set sh = ThisWorkbook.Sheets("mn") --- giving error this line "script out of range" i have created sheets january to december **** I want that data should be record in the month as per month in the date text box ***
@thedatalabs2 жыл бұрын
Please check the output of mn whether it's showing the correct month or not. Also mn is variable hence you should not enclose with single or double quotes. Thanks!