getting “Argument not optional” when calling a macro in worksheet change
I’m getting the error “Argument not optional” when trying to call a macro on a worksheet change. What I’m trying to do is anytime something is changed in column A then run macro1, anytime something is changed in column E then run macro2, and anytime something is changed in column H then run macro3. Here is the code I’m using:
VBA Compile Error “Named argument not found” for line “Link:=True”
I’m new with VBA, I took little by little pieces from different codes and I have a code which supposed to check first if the file exists, if it does, then it makes new sheet on existing workbook with name “WK 40” and copies all information from that file, mostly important – with links, so in case if in original file will be added something, then it will update automatically in my file. I have an error “Named argument not found” showing me on “Link:=True”.