first row

  1. S

    Filtering Using VBA, can get rid of first row

    I have the below code that goes to sheet OnOrder, filters for the data in cells F2 and A2 in the HOME tab and then copies that data and pastes in into cell AU17 in the APR tab. The problem is that when it pastes the data it's taking exactly what I need AND the first row. In this case row 2. So...
  2. B

    Find 1st empty row in data base issue

    I need the code I have for finding first empty row to ignore the data i have in column A. I have data in row 1 also. Im not sure how to adjust the code below. Thanks for the help as always iRow = ws.Cells.Find(What:="*", SearchOrder:=x1Rows, _ SearchDirection:=xlPrevious...
  3. A

    Selecting a Variable Range by First Row and Last row

    Hello I am struggling to select a variable range based on the second row and last row. All I want is to select the entire rows between the variable second row till the last row. And then I want to sort them. I am able to define the last row easy which is quiet straightforward. And I am also...
  4. E

    Copy and paste a row

    Hello people, I need help with a code that copy the first row from the sheet sheetname"test" and put it on row 1 into the sheetname "Statistics" Could someone help me? Thank you in advance

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