sheet11

  1. P

    Find and Replace Code to Multiple Subs

    Hi can anyone help with replacing the lines in RED with the lines in Blue to multiple subs? Sub dups1() Sheets("Sheet11").Select Dim Sheet11 As Worksheet: Set Sheet11 = Sheet11 Dim lRow As Long lRow = Sheet11.Cells(Rows.Count, "A").End(xlUp).Row Range("A1:BD" &...
    • pwill
    • Thread
    • dim lrow rangea1.select selection.autofilter sheet11
    • Replies: 7
    • Forum: Excel Questions
  2. S

    Count for duplicates

    Hi there, My formula is not returning what is should be returning. I've checked it over and I think it is good. =SUMPRODUCT((COUNTIF('Data Sheet'!1:1,'Data Sheet'!1:1)-1)*('Data Sheet'!1:1<>""))>0 Can anyone tell me what is wrong with it?
  3. H

    ComboBox Value in WorkSheetFunction SumIfs

    Hello, Hope you are well. Is it possible to use a combobox value in the SumIfs WorkSheetFunction? As I have the below code that caculates the Net Value of weights in Column E on Sheet11 if the Farm name and Type of Drying method for grapes is in Column A and C. The Farm name and Drying...

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