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
|