range calculations
 

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

range calculations
 

Just
Range("E1:E100").Value = "=D5 / 100000"

"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

range calculations
 

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

range calculations
 

Thanks that did it. I didn't realize I could put my starting row in the
first cell and the rows would advance as it moved down the range.

Thanks
Mike

"Alok" wrote:

Just
Range("E1:E100").Value = "=D5 / 100000"

"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