data rows

  1. Small Paul

    VBA Fails When Only 1 Line of Data

    Hi I have a vba which starts with the following: ActiveSheet.Name = "Salesforce Download" Dim lastrow As Long Application.ScreenUpdating = False Application.DisplayAlerts = False Setmyrange = range("A2", "A" & Cells(Rows.Count, 1).End(xlUp).row) Application.ScreenUpdating = False...
  2. D

    COUNTIFS on range that is expanding more than 1k rows will get frozen :(

    Hi All, The formula below works just great for me but the calculation will not move at all when the data rows is more than 1k. Can somebody help to amend the below code to allow me to have what I need regardless the data rows, please? This formula is actually calculates number of staff who...

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