formulaArray problem

**dave3n3** · 06-15-2009, 06:08 AM

Hello everyone

Is is just a minor problem, but I don't seem to be able to solve it, so i would be thankful for some advice. My problem is, that these 3 lines:

Please Login or Register  to view this content.

give me the following output (in my example endcell is 5573):

=KernRegPs("C5:C5573;C4:C5572;F4:F34;0.25")... what i need is:
=KernRegPs(C5:C5573;C4:C5572;F4:F34;0.25), so how do i get rid of the quotation marks?

thanks
david

**DonkeyOte** · 06-15-2009, 06:25 AM

Your Formula string should read:

Please Login or Register  to view this content.

(use .Formula if you don't need an Array formula)

**dave3n3** · 06-15-2009, 07:56 AM

thanks, but i got some range class error. i came up with a solution though..

Please Login or Register  to view this content.

not sure, why your line did not work.

greets
david

**DonkeyOte** · 06-15-2009, 08:02 AM

Help states you should use R1C1 when entering FormulaArray but I don't think that hods true 100% of the time... that said R1C1 is always better for entering formulae from VBE IMO... also I was using ; delimiter as inferred in your original post.

EDIT: and thanks for posting up your own resolution, it is appreciated as it may help others who stumble upon this thread whilst trying to resolve their own problems.