| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 12072 | 2001-10-14 19:23:00 | vba problem | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 21421 | 2001-10-14 19:23:00 | Each of the two following lines of code work separately but not the third. Can someone help please? ActiveCell.Formula = '=SUM(RC[1]:RC[10])' ActiveCell.Formula = '=t7' ActiveCell.Formula = '=t7' - '=SUM(RC[1]:RC[10])' |
Guest (0) | ||
| 21422 | 2001-10-14 20:45:00 | Try this instead: ActiveCell.Formula = '=t7 - SUM(RC[1]:RC[10])' This will paste the formula, '=t7 - SUM(RC[1]:RC[10])' into the cell. |
Guest (0) | ||
| 21423 | 2001-10-15 09:14:00 | Thanks Scooby Do but I want thr value in the cell not the formula the first two code lines give the value aafter that I can only get the formula or NAME!? | Guest (0) | ||
| 1 | |||||