depends

  1. S

    Automation in excel

    Hi All, I'm a basic excel user and dont know how to automate my requirement using excel. I know excel is powerful and as i dont have programming background i'm not able to understand the vba. Can someone help me here. My requirement is I have few questions where I get answers from users. For...
  2. D

    Selection.AutoFill Destination:=Range Question

    I recorded a macro to do an autofill, the first time it ran it only had 100 rows, but the rows count can change. How would I make this macro work depends on how many rows there are? Column A will always have the correct number of rows. Selection.AutoFill Destination:=Range("N4:N100")...
    • drozek
    • Thread
    • depends macro rows selection.autofill work
    • Replies: 8
    • Forum: Excel Questions
  3. A

    VBA code required to SUM the value depends on multiple criteria

    Hi In the below link excel sheet has dropdown list in the cell P1. In the cell EL1 will shows the results depends on the P1 selection For that, I used If, sumproduct and index match formulas in the cell EL1 as below. --...
  4. K

    Boolean test for dependency between 2 cells

    How can I test whether one cell is dependent on another? I tried the following, but does not seem to work: Function Depends(Cell_B As Range, Cell_A As Range) As Boolean If Not Intersect(Cell_B, Cell_A.Dependents) Is Nothing Then Depends = True Else Depends = False End Function

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