Hey everyone, I’ve got this user-defined function that I use to calculate a statistical measure for a range of cells. I’d like to modify it so that it only evaluates the visible cells within the range, but I’m not sure exactly how…
Here’s the current code:
Function COD(r As Range) As Double...
I have a document with over 21,000 lines. The spreatsheet is totaling orders over the past year: each orange order amount and total charge is a hidden line and only the totals are visable, there could be 876 orders for oranges so when I copy and paste, all 876 lines plus the total (line I want)...
Dears,
First of all thank You for Your help I got from You till now (i have been visiting this forum since a long time but registered only now as i am unable to solve one problem). !
Here is my question to You.
I have some data in Range("F1:J364"), it is filtered (i exclude all #N/A`s) - for...
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.