Here' s my code Sub generateMatrix( size, lowerbound, upperbound) For i = 1 To size For j = 1 To size. Hi Everyone, I am pretty new to this VBA stuff and am trying my best to work this out myself. I am working up a program that will eventually find data. I have this VBA code, when I try to run it, it gives me " Compile error: Syntax error" as can be seen in the image. I don' t know VBA, what should i do to make this. I' m having some trouble with syntax options while writing a VBA Macro for Excel. In VBA you can call a method on an object in two different ways: foo.