| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell formulas with VB
Yes
Dim i As Integer Dim s As String s = "Dan" i = 504 Range("A2:A90").FormulaArray = "=SUM((" & s & "!$E$1:$E$" & i & "="""")*(" & s & "!$B$1:$B$" & i & "=A2))" Also your formula has a circular reference to A2 --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two formulas in on cell based on two numbers in another cell? | Excel Discussion (Misc queries) | |||
| Carrying formulas over to new cell when old cell is deleted: possi | Excel Worksheet Functions | |||
| How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
| Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
| change cell value greater than another cell value using formulas | Excel Worksheet Functions | |||
![mudraker[_164_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
