Mike:
try,
Row = 5
Range("E1:E100").Formula = "=D" & Row & "/100000"
--
天行健,君*以自強不息
地勢坤,君*以厚德載物
http://www.vba.com.tw/plog/
"Mike" wrote:
If I am try to put an equation in a cell how do I reference the cell
Range("E1:E100").Value = "=D<row / 100000"
Obviously this doesn't work but what would be the correct syntax to do
something like this. I don't want to do a loop.
Thanks
Mike