data_end_row_number

  1. T

    Issues with autofilters

    I have been experimenting with auto filters and was wondering if there is a way that i could get it to copy the information to another workbook but don't know how. Can anyone help me? Here is what i have so far but i don't know why it doesn't work. Hopefully what i'm trying to do is possible...
  2. P

    On Error Messages

    I have the below formula. I need an On Error message prior to this line of code "data_end_row_number = ws.Range("A1").End(xlDown).Row" that will pop up a msg box that says some information for why error is happening. After msgbox, i just want macro to end. I cant trying different methods but I...
  3. P

    Run-Time Error 1004

    I have the below code, it looks for a filter criteria in column V and then it will take filtered criteria and paste in a separate. However, sometimes there might not be any data filtered and thus get the "No cells were found" error. Any assistance? Sub copy() 'source worksheet Dim ws...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top