Name Manager

%3CLINGO-SUB%20id%3D%22lingo-sub-3080075%22%20slang%3D%22en-US%22%3EName%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3080075%22%20slang%3D%22en-US%22%3E%3CP%3EHulp%20gevraagd%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Foutmelding.JPG%22%20style%3D%22width%3A%20698px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343332iFC97EF3866BB951F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Foutmelding.JPG%22%20alt%3D%22Foutmelding.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22fout.JPG%22%20style%3D%22width%3A%20448px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343333iFD1A647C7686E1CD%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22fout.JPG%22%20alt%3D%22fout.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3080075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3080181%22%20slang%3D%22en-US%22%3ERe%3A%20Name%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3080181%22%20slang%3D%22en-US%22%3EIf%20you%20use%20Dutch%20system%20settings%2C%20replace%20the%20commas%20%2C%20in%20the%20formula%20with%20semicolons%20%3B%20%3DOFFSET(Data!%24D%245%3B0%3B0%3BEngine!%24C%243%3B1)%3C%2FLINGO-BODY%3E
Occasional Contributor

Hulp gevraagd

Foutmelding.JPGfout.JPG

2 Replies
If you use Dutch system settings, replace the commas , in the formula with semicolons ; =OFFSET(Data!$D$5;0;0;Engine!$C$3;1)
U bent geweldig, ik heb hier dagen over gedaan om er achter te komen wat er nu fout was.
Ik heb idd de NL systeeminstellingen, maar de taal op Engels om zo goed mogelijk Vba onder de knie te krijgen. Nu weet ik waarom er op mijn werk diverse formules wel werkte maar thuis niet.
Nogmaals hartelijk dank.