nxtrw

I am battling to figure out how to make this easier. I need to take the data from a multi-page of "Comboboxs" and "Textboxs" to a specific sheet. I have code that works, but its going to be a lot of work and I have 2 tabs I have to do this for. Private Sub CommandButton2_Click()...

Hi, I have this code for file path for the Invoice PDF. Private Sub CommandButton1_Click() Dim NxtRw As Long, CurrentPath As String, wFile As String On Error GoTo EnEvents If Range("J3").Value = "" Then NxtRw = 3 Else NxtRw = Range("J2").End(xlDown).Offset(1).Row End If...

Hello, I have a cell value that I would like as the PDF file name plus today's date included in the name. For instance: HAN6597 8/12/2019 Is this possible to do? Also what if the same customer code (in cell H2) and same date are sent to PDF more than once? Does the PDF get replaced or...

Could print to PDF be added to this button? My print area is B2:H53 Private Sub CommandButton1_Click() Dim NxtRw As Long Application.EnableEvents = False If Range("J3").Value = "" Then NxtRw = 3 Else NxtRw = Range("J2").End(xlDown).Offset(1).Row End If Range("J"...

Hello, please can you help me with the code below that works great but i just wanted the data in the form to clear once the add button has been pressed and all data has be transferred to the other sheet, is there any way for it to 'Clear' once the button is pressed? please can you help me...

I use the following code to add a date into the first available cell in column S Private Sub Skip_A_Student_Click() Dim Cnt As Long Dim NxtRw As Long NxtRw = Cells(Rows.Count, "S").End(xlUp).Offset(1).Row Cnt = WorksheetFunction.Count(Range("S2:S" & NxtRw)) Range("S" &...

I am using the below code to cleanup a bunch of workbooks. I came across a workbook that does not have any data inputted below row 1. Row 1 contains the headers. The macro keeps throwing the generic error "Run-time '1004': Application-defined or object-defined error". Clicking the debug issue...

Hey all, Wondering if anyone can help me. Basically I have a number of sheets in a workbook that I need my VBA to search through for any rows that contain a date within a range, copy that information and paste it into a specified sheet. I have it working for a single date using VBA but...