Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Calculations | Excel Discussion (Misc queries) | |||
Named Range Calculations | Excel Discussion (Misc queries) | |||
Need formula help setting a range for calculations | Excel Worksheet Functions | |||
Any way to get calculations over a range of two sheets? | Excel Worksheet Functions | |||
Auto cell range calculations | Excel Programming |