rng3

  1. 5

    Count only visible data after filtering

    ​Hi, what do I need to add to the below code to only count the visible data after filtering. I assume it is possibly .SpecialCells(xlCellTypeVisible) or similar after With Worksheet("calculations"), but I can't figure it out. Help appreciated. Sub Count_only_visible_data()With ActiveSheet...
  2. T

    Application Intersect Issue

    I have the following code Written to open my calendar whenever someone clicks on the targeted cells. However, I get a Method Range of Object worksheet failed Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim rng1 As Range, rng2 As Range, rng3 As Range Set rng1 =...
  3. M

    Subtracting one value from an existing value based on a cell description

    Hi All, Thanks in advance for any help. I am trying to get a code to Subtract a value from a cell on another sheet using another cell name as the trigger. IE if sheet 1 cell A1 = 12345 the code must look up 12345 on sheet 2 and subtract sheet 1 cell 2 from sheet 2 say B8 (whichwere row it finds...

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