b.endxlup.row

  1. T

    Slow VBA routine; code appraisal?

    Hello, Hope someone can help. I have inherited a routine that takes around three hours to parse approximately 60,000 rows of data. What it has to do is cut data from an initial dataset (the 60,000 rows) and then paste into either of two other sheets depending on some criteria. I have...
  2. D

    Multiple Criteria & Sum VBA Code

    Hello, Hoping someone can help me with he below. I have onemore I’m trying to add in, but I have no clue on how to do it. Last FreeDay Sheets(1) “Data” Column B:B = (Date Value) I Need toget a date value based on multiple criteria and sum 1st- Match Sheets(1) “Data” Column AZ...
    • dbnfl
    • Thread
    • .filldown .value b.endxlup.row column end
    • Replies: 0
    • Forum: Excel Questions
  3. M

    R1C1 formula 1004 error

    HI Brains trust I have an issue in that when trying to insert a formula into my table i get a 1004 error and bumped in to debug mode. the following code is from the macro I am working on. code in green is working but code in red does not work. LastRow = Cells(Rows.Count...
    • Mpotten
    • Thread
    • b.endxlup.row cellsrows.count code formula lastrow
    • Replies: 3
    • Forum: Excel Questions
  4. D

    How to apply number format to multiple column using loop or best way?

    I am applying number format to multiple columns using the following code. however, I would like to optimize it so that it runs faster.
    • dmadhup
    • Thread
    • 17.numberformat b.endxlup.row format multiple number
    • Replies: 2
    • Forum: Excel Questions
  5. M

    Copy non blank rows from one sheet and paste on another sheet on the first available blank row

    Hi there, I have a macro that is not working properly. When I run this, it copies 100 rows and 10 columns, which are blank and non blank, and paste it at the destination Sheet LIST and TOTAL LIST. The Sheet "LIST" gets cleared before the macro is run next time. When the macro is run again, the...

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