My Excel macro works differently at work than home.

Question

Hello everyone.&nbsp;&nbsp;I have a Excel macro that seems to work perfect at home however at my work PC I get a run time error 13. When I look at the VBA it highlights an error with my:&nbsp; rng/Value&nbsp; &nbsp;....&nbsp;MY goal of this sheet is to enter a begin and end date, this will provide a series of 1 to 7 values based on those dates. Only the values would be shown and the others not applicable would be hidden, which this also applies to the tabs .&nbsp;&nbsp;I will also note, my old workstation worked flawlessly though that needed an update from our tech support. Now that I have transferred, I am worried if my employer wants to use this Excel sheet, the entire department will need an update.&nbsp;&nbsp;Any advice? Thank you in advance for your time and support.&nbsp;&nbsp;&nbsp;&nbsp;

hansvogelaar · Answer

James818&nbsp;
I see that the FILTER formulas return #NAME! in the second screenshot.
The FILTER function is only available in Excel in Microsoft 365 and Office 2021. Which version do you use at work?

james818 · Answer

Office 365 Plus at work.

hansvogelaar · Answer

James818&nbsp;
Office 365 might be too old for the FILTER function.

james818 · Answer

Do you have any recommendation based on my objective to at least enter a start and end date to provide the variables that apply that I can use on Office 365?

hansvogelaar · Answer

James818&nbsp;
In B5 as an array formula confirmed by pressing Ctrl+Shift+Enter:
&nbsp;
=IFERROR(INDEX(Sheet3!$A$2:$A$8, SMALL(IF((Sheet3!$B$2:$B$8&lt;=IF($B$3="", $B$2, $B$3))*(Sheet3!$C$2:$C$8&gt;=$B$2), ROW(Sheet3!$B$2:$B$8)-ROW(Sheet3!$B$2)+1), ROW($B5)-ROW($B$5)+1)), "")
&nbsp;
Select B5 and copy it.
Select B6:B11 and paste as Formulas.

Forum Discussion

My Excel macro works differently at work than home.

Share

Resources