use variable value argument for function "text"

Hello,

I am copying text from a source worksheet (msi) to a destionation one (tabella).
I am writing formulas on the cells of the destination wk which copy the content of
cells in the source wk using the function "text".
Syntax of "text" function is

text(value, format)

How can I give a variable cell (cell whose rox/column vary in a cycle) as first argument of function "text"?
See lines 6 and 7 below.

1     'write amplitude pattern
2     
3     Set mySh = ThisWorkbook.Worksheets("tabella")
4     With mySh
5         	For lRow = 0 To 59
6         		Set rng = Range("B" & lRow + 7)
7         		.Cells(lRow + 9, 3) = "=text(msi!rng;""#.00"")"
8         	Next
9     End With

Thank you, giovanni