| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering Sum formula into a cell
try
=SUM(startrow:endrow) "Parker" wrote in message ... I am having trouble entering a sum formula from a macro into a cell. I have defined variables called 'StartRow' and 'EndRow' and I want to enter a sum formula for column N from 'StartRow' to 'EndRow' into the active cell. I don't know how to incopropate the variables into the sum formula. Any help would be greatly appreciated. Thanks in advance! Parker |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering Formula - Cannot select cell as it is hidden by formula | Excel Worksheet Functions | |||
| Warning when in another cell after entering a formula. | Excel Worksheet Functions | |||
| entering a formula into a cell with text | Excel Discussion (Misc queries) | |||
| How to protect cell with formula from being entering info | Excel Worksheet Functions | |||
| Formula is entering a default time when it comes across an empty cell.. | Excel Worksheet Functions | |||
![Don Guillett[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
