inserting a formula with a dynamic cell reference

As part of more code, the below line is included in what i am doing to populate a worksheet. I need the reference to cell B6 be dynamic to the current row. column B will be static. i have tried R1C1 and a few other things but i have not been able to get it right. The formula once inserted works fine, its just referencing the wrong wrong customer/row.

Thanks for any help or suggestions.

Please Login or Register  to view this content.

Thanks Bernie.

Just needed to add offset to r to get the correct row.

Please Login or Register  to view this content.