Forum Discussion
Using VBA to have a cell equal a sum of cells in another worksheet
Hello, I'm trying to create a vba macro that allows me to clear the current value of cells in one spreadsheet and then have the cleared cell be set to the sum of a range of cells in another sheet. I'...
Thank you! The code is working and setting the value of the cells to 0 as it should. However, is it possible to set the cells formula as =SUM(" : ") for the range in the Invoices and Purchase Orders sheets such that the cells in BS & IS update with new entries? Would I have to do
Worksheets("BS & IS").Range("C6").Formula = ...in order for this to happen?
Yes. In that case, don't use WorksheetFormula, but set the formula of those two cells.