| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding formula to cell
Hi
I seem to have problems to add a formula to a cell. I generat a string like "=SUM(A1;H7;U7)" and apply it like ActiveSheet.Cells(y + k + 1, x + 1).Value = sValue ActiveSheet.Cells(y + k + 1, x + 1).Text = sValue ActiveSheet.Cells(y + k + 1, x + 1).Formula = sValue and the all give an "object error" why???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding formula to a cell with VB | Excel Programming | |||
| formula for adding every other cell in Excel | Excel Worksheet Functions | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
| Adding a prefix to a cell by using a formula | Excel Discussion (Misc queries) | |||
| Adding a comment to a formula-not a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
