Convert array formulas into code

[RAJESH SHAH]

Hello code experts
I have formulas in 35 columns in a single sheet worksheet. I need your expertise and help to convert these formulas into code and get the values with the help of a code. Some of the formulas are array formulas and some just formulas. I tried comparing with codes from previous applications where the formulas are converted into code but failed to do edit the code. I am not so good at defining the variables nor at array formulas. I would really appreciate any help received.

[JEC.]

Here you go

Please Login or Register  to view this content.

[RAJESH SHAH]

I think you misunderstood my query or maybe I was not very clear enough about it. There will be only headings in the sheet 2A Extract. The code will fill the row 2 with values. So, each formula is to be converted into code and then through the code the values are derived in the sheet. Like in Expected Result sheet.
If I get the correct values then I can use the resize code connected to another sheet which is not in the workbook but the code to resize is ready.
After converting the formulas into code and using that code Print values in row 2 in the 2A Extract sheet.