1.endx1up.row

  1. C

    VBA copy and pasting into different tab at the end of the last empty row

    i currently have this: Set wb = ThisWorkbook Set sh1 = wb.Sheets("Query") Set sh2 = wb.Sheets("Credits") Set sh3 = wb.Sheets("Duplicate") Set sh4 = wb.Sheets("Rev Rvsd") Set sh5 = wb.Sheets("Rebills") Set sh6 = wb.Sheets("Pivot") Set sh7 = wb.Sheets("Work") Set sh8 = wb.Sheets("Removed") Set...
  2. D

    finalrow = Cells(Rows.Count, 1).End(x1Up).Row Getting a error that I can't get past

    I'm using the below VBA to return information from 2000's rows of data and I keep getting an error when using the line finalrow = Cells(Rows.Count, 1).End(x1Up).Row. Any help would be appreciated! Sub finddata() Dim datasheet As Worksheet Dim reportsheet As Worksheet Dim agentname As String...
    • DarrenF
    • Thread
    • 1.endx1up.row agentname cellsrows.count dim finalrow
    • Replies: 3
    • Forum: Excel Questions

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