VBA LOOPING FORMULA TREND

[montecarlo2012]

Hello everyone, Hoping you got good weekend and safe.
PLEASE, hard time figuring things out here with looping a formula.
The same formula must be entered in the successive cells columns, the formula must be incremented By one row.

The reading area to apply the formula contains a dynamic array of data, in (“B2:G2800”) at the moment
The formula TREND of each Column in the data BLOCK is to be calculated and entered in the first
8 rows of columns;
if any result match, like B with B or C with C highlight and count beyond column I

CELLS(I3 , N).FORMULA=TRUNC(TREND(B3:B11))
CELLS(I4 , N).FORMULA=TRUNC(TREND(B4:B12))
CELLS(I5 ,N).FORMULA=TRUNC(TREND(B5:B13))
CELLS(I6 , N).FORMULA=TRUNC(TREND(B6:B14)) The difference is 8



In the answer area (“P:N”) the formula would be increase again
CELLS(P3 , U).FORMULA=TRUNC(TREND(B3:B12))
CELLS(I4 , U).FORMULA=TRUNC(TREND(B4:B13))
CELLS(I5 , U).FORMULA=TRUNC(TREND(B5:B14))
CELLS(I6 , U).FORMULA=TRUNC(TREND(B6:B15)) The difference is 9

I want to keep going until the difference is equal to 35
On “I3” you see the number 3 is because three time the numbers on column B, match the results on B.

 

[montecarlo2012]

StephenCrump, Sorry about this, I just now have time to really work with the code, and I realize something about the values in the row 3,
I am not getting any results, all I see is Value#, Value# etc. and about the 2800 rows is just a reference quantity at the present time, but the array is dynamic I was thinking maybe use lastrow.count instead of the 2800, maybe ?, my apology for this comment Sir.
Thank you again for reading this post.

 

[montecarlo2012]

Thank you StephenCrump, I make a mistake, I founded and now is perfect, thanks again, I was wrong and you are right, sorry.

 

[StephenCrump]

No problem. I am glad you got it working.