reason

  1. U

    Applying Array formula on the results of another array formula

    I have this formula {=SMALL(N2:R2,{1,2,3,4,5})} in (U2:Y2), when I try to use this formula =IFERROR(INDEX($U2:$Y2,SMALL(IF($U2:$Y2=0,COLUMN($U2:$Y2)),COLUMN(U:U))),"") on (AB2:AF2), It doesn't give any error or result. But I know this formula works, I used it before. Can it be the reason that...
  2. deletedalien

    Simple VBA question (i think)

    i have this line of code: If Worksheets("Summary Inbound").Range("A1").Value = "Error" Then GoTo Exit1 Exit1: Application.ScreenUpdating = True MsgBox "Error", vbCritical Exit Sub and the following formula in Summary inbound A1...
  3. Z

    Formula ? Trying not to use " "

    Hi I am trying to avoid using "Data " I need to use Data! without the "". Is there a way to do these formulas different and work the same way. Maybe not using the indirect way. Reason cause I ahev to switch the sheet name sometimes and the " " mess it up thanks =INDIRECT("Data!$E$2")...
  4. B

    Help with Variable Use

    I have the below variable I am using. Dim SetFormulasLeipsic As Long SetFormulasLeipsic = Sheets("DataB1toDUKE").Range("A" & Rows.Count).End(xlUp).Row Range("A2:Y2").AutoFill Destination:=Range("A2:Y2" & SetFormulasLeipsic) When I F8 through it SetFormulasLeipsic captures the...
    • Blauv
    • Thread
    • adding autofill reason setformulasleipsic variable
    • Replies: 3
    • Forum: Excel Questions
  5. F

    Dynamic named range ?

    Hi guys I'm struggling to make my named ranges dynamic :/ I have two lists in name manager: currency =Conversion!$B$63:$B$70 and: mycurr =Conversion!$B$63:$D$70 However I need those list to be dynamic without putting them in a table. I tried this for currency...

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