Set ForumlaArray property

[mtnbiker98]

Hello, All.

I have researched this error quite a bit and still cannot find a fix to the code below. I am trying to set an Array Forumla using VBA. The formula is less than 255 characters.

Any advice would be greatly appreciated.

Please Login or Register  to view this content.

[JosephP]

typo in 'forumla'

Please Login or Register  to view this content.

oughta be

Please Login or Register  to view this content.

[mtnbiker98]

Good catch! Missed the simple thing.

I do still, however, get the same error with the corrected formula.

[JosephP]

you didn't actually say what the error was?

I reckon you don't want one array formula for the whole column though-did you mean this (untested)

Please Login or Register  to view this content.

[mtnbiker98]

What you wrote above worked. I did not use the third line of code as when the formula is inserted, it automatically autofills the rest of the table.

My question does the "with" construct change how the formula is being inserted? My untrained eye does not see a whole lot of difference between.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Thanks for your help!

[JosephP]

your code was attempting to array-enter the formula into the entire column at once, which won't work, whereas mine put an array formula into the first cell-note the .Cells(1) part

[mtnbiker98]

I do see that your code is dropping it in a particular cell rather than the whole column. I guess the "with" probably isnt what is making the difference there.

[mtnbiker98]

your code was attempting to array-enter the formula into the entire column at once, which won't work, whereas mine put an array formula into the first cell-note the .Cells(1) part

Thanks, Joseph. I appreciate your help on this one.

[JosephP]

Using With rarely makes a difference to how code operates-it just saves typing and can speed code up