Hi,

I have a Match offset function written in Excel VB.

The maximum number of cells that the formula can go to is 2000.

But, I am looking to have the formula dynamic.

Eg: if I submit one value in C8, I see the result in B8 as per the formula.

But, I see formula from B8 to B2000 cells. I want the formula to appear based on the source cell.

For eg. If I have values in C8,C9 and C10, the formula should be in B8, B9 and B10.

I do not need the formula to come till B2000. Is there a way I can make it dynamic. Below is the code for the range.


Range("B8").Select
Selection.AutoFill Destination:=Range("B8:B2000"), Type:=xlFillDefault
Range("B8:B2000").Select
Range("B2000").Select

Thanks in advance