nxtrw

  1. E

    Userform to Sheet Row\Columns

    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()...
  2. L

    File Path By Year and Month

    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...
  3. L

    Name of PDF From Cell Value

    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...
  4. L

    Add PDF to Button

    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"...
  5. P

    Clear form after add buton is pressed and data transferred onto other sheet

    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...
  6. P

    code to clear a cell

    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" &...
  7. Z

    Help Debug Issue with Macro Code

    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...
  8. J

    VBA Date Range - Overflow problem

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top