Insert array function in macro

[b_rianv]

Ok so I have figured out the first part of my macro to do formula in a added cell.

Please Login or Register  to view this content.

But need help with this one.
I am trying to get a macro to do the ODD/EVEN PATTERN for my numbers with this formula.



as a macro. So when I click my insert button everything is done automatically, then all I have to do is input the data in to the cells.

Can someone help??

I have attached the workbook

Thank you,

[b_rianv]

Sorry forgot to add a Subject to post.....Subject: Macro pattern

Please forgive me, in a hurry to get off to work and was up all night trying to figure this out

Brian

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[b_rianv]

Add title...

So I have these macros working

Please Login or Register  to view this content.

This is to add a new row in my database

This is to add first formula to cell after adding a new row

Please Login or Register  to view this content.

Just need help with the odd/even pattern macro with this formula
=IF(ISODD(B2),"O","E")&IF(ISODD(C2),"O","E")&IF(ISODD(D2),"O","E")&IF(ISODD(E2),"O","E")&IF(ISODD(F2),"O","E")&IF(ISODD(G2),"O","E")...enter as a array

So when I click my button in the sheet all everything is done and then I can input my dtata.

[zbor]

Try

Please Login or Register  to view this content.

[b_rianv]

I will test this tonight when I get home from work

[b_rianv]

Work perfectly!! Thanks Zbor. I was using the {} in my macro instead of typing (FormulaArray) which you did.

Thanks again