lnglastrow

  1. K

    Vary row number in a VBA formula

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I have a formula sumproduct running in the VBA =SUMPRODUCT(--($I$8:$L$8=C8:F8)) I want a loop once this formula is filled restart again filling with change of row number =SUMPRODUCT(--($I$9:$L$9=C8:F8)) change as long as data find in the column C...
  2. A

    How to auto-fill until the last row of data based on user-specified input on a separate worksheet

    Hi everyone, I'm trying to autofill column A in "Master Publisher Content" based on a user-specified value in "Enter Info" in cell H3. The catch is that I only want to fill column A based on the last row of data in "Master Publisher Content." I'm using column C to find the last row of data, but...
  3. L

    Split large list into several sheets

    Hello, I have a very large list of emails around 200,000 and I need to split them into several sheets of 40,000 on each. I have been able to accomplish this with the following but how do I copy the headers over to each sheet? Sub SplitWorksheet()Dim lngLastRow As Long Dim lngNumberOfRows As...
  4. C

    VBA to fill down 10 rows

    Ok guys I am finally giving up after trying to work this outfor most of the day. I have a code that takes me to the last row of formulas I have copied down. It then selects that entire row.I would like it to be able to then fill down from this row to the 10 rows below. I can manually drag the...
  5. A

    VBA Question for Range on open ended Columns

    I used the Macro Recorder to get the basics, added in for Criteria1 and Criteria2... All worked good till I needed to select certain rows and available cells... Here is the code I am using with all the "Failures" for selecting the ranges.. Application.ScreenUpdating = False Dim Startdate...
  6. J

    Finding the last used cell not giving the desired result

    Hi I have an autogenerated worksheet in sheet1 I am trying to create a macro for which I want to find the last used cell in column "D". The data in column D start from row 6 and when i am using the row.end method to find the last used row i am getting the value as 1 instead of 2843. The code...

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